| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for empty row
Dear Excel-perts,
How must I test for an empty row (countif?) in a macro and subsequently delete this row? I made a worksheet which fits in an A4-format in order to print one page. This sheet is filled in by guest users and sometimes they write more than one line in a cell, so its height doubles. Is there a test to measure the height of the total sheet? By deleting empty rows in this sheet I could try to make the hight of this sheet fit again in the A4-format. Thanks in advance, MahrYon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I test if a cell is empty? | Excel Discussion (Misc queries) | |||
| Test if the range is empty | Excel Discussion (Misc queries) | |||
| Test for an empty selection | Excel Programming | |||
| Test if Clipboard is empty | Excel Programming | |||
| Better way to test for empty Recordset | Excel Programming | |||
Threaded Mode
