Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
With a loop like this: Do While ActiveCell < "" 'Loops until the active cell is blank. ... ActiveCell.Offset(1, 0).Select Loop one can loop through a worksheet column until a cell is blank. Is it also to possible to loop until the end (I mean, to continue even when several cells are empty but non-emtpy cells are still present)?? (I would like to obtain the number of non-empty cells, or the index of the last non-empty cell, but don't know whether such a function exists). Thanks in advance, Jonne. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I specify an end to a worksheet to eliminate empty rows? | Excel Discussion (Misc queries) | |||
empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
Saving a worksheet without empty rows | Excel Programming | |||
Delete empty rows in a worksheet | Excel Programming | |||
Number of rows not empty | Excel Programming |