General discussion

Locked

Find first empty cell in Excel column?

By Dave DiLella ·
I need to have a macro find the first empty cell in a column of data. CTR <down arrow> works but not if I use it in a macro.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Find first empty cell in ...

If you record the macro, you'll find that the equivalent is:

Selection.End(xlDown).Select

Collapse -

by DKlippert In reply to

To select the first empty cell in a column
Range("A1").End(xlDown).Offset(1, 0).Select

To select the first empty cell in a Row
Range("A1").End(xltoRight).Offset(0,1).Select

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums