View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bodhisatvaofboogie bodhisatvaofboogie is offline
external usenet poster
 
Posts: 93
Default Selecting Blank Rows

How do I select all blank rows in my document down to the bottom...what would
the formula look like?

AND

How do I make an IF statement out of this information?


If (cell = 15) Then
cell.Offset(-1).Resize(15 - Range("a1")).EntireRow.Insert
End If

Because that doesn't work.....

THANKS!!!