First Empty Cell?
 

Hello,

I currently have this in part of my Sub, which basically selects a range
from the active cell to the last nonempty cell.

Range(ActiveCell, ActiveCell.End(x1Down)).Select

Question: How do I get it to select the first cell that is empty?

First Empty Cell?
 

Nevermind I got it,

ActiveCell.End(xlDown)(2, 1).Select

"Gabe" wrote:

Hello,

I currently have this in part of my Sub, which basically selects a range
from the active cell to the last nonempty cell.

Range(ActiveCell, ActiveCell.End(x1Down)).Select

Question: How do I get it to select the first cell that is empty?

First Empty Cell?
 

Hello Gabe,

This will select the first empty cell at the bottom of the column the
active cell is in. Not really sure this what you want though.

ActiveSheet.Cells(Rows.Count, ActiveCell.Column).End(xlUp).Offset(1,
0).Select

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=505928