lior03
07-03-2006, 06:44 AM
hello
i am trying to add row to a non empty selection of cells.so under each filled row of data there will be an empty row.what is wrong with...
Dim cell As Range
For Each cell In selection
If Not IsEmpty(cell) Then
cell.EntireRow.Insert
End If
Next
thanks
i am trying to add row to a non empty selection of cells.so under each filled row of data there will be an empty row.what is wrong with...
Dim cell As Range
For Each cell In selection
If Not IsEmpty(cell) Then
cell.EntireRow.Insert
End If
Next
thanks