| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
| Selecting non-blank cells | Excel Discussion (Misc queries) | |||
| Macro selecting blank rows/columns | Excel Programming | |||
| selecting the last non blank row. | Excel Programming | |||
| Selecting first blank row | Excel Programming | |||
Linear Mode
