ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting Blank Rows (https://www.excelbanter.com/excel-programming/367854-selecting-blank-rows.html)

bodhisatvaofboogie

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!!!


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com