| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically finding the first empty cell
Hi Bob,
firstEmptyCell = Range("B15").End(xlDown).Offset(1,0).Address returns the address of that empty cell. But beware. it throws an error if B16 is empty, so best to test for that explicitly and if so, bypass that statement. heavy thanks :o) Best regards, Markus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
| Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
| Finding the first empty row with VBA | Excel Programming | |||
| Finding first (end of range) empty cell | Excel Programming | |||
| Finding the next empty cell. | Excel Programming | |||
Hybrid Mode
