Discussion Locked

Find first empty cell in Excel column?

0 helpful

2 replies

by dave dilella Apr 21, 2004 last reply Apr 21, 2004

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to have a macro find the first empty cell in a column of data. CTR works but not if I use it in a macro.

2 replies

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

Selection.End(xlDown).Select

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

This discussion is closed to new replies.