First Empty Cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gabe - 28 Jan 2006 00:39 GMT

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?

Reply to this Message

Gabe - 28 Jan 2006 01:11 GMT

Nevermind I got it,

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

> Hello,
>
[quoted text clipped - 4 lines]
>
> Question: How do I get it to select the first cell that is empty?

Reply to this Message

Leith Ross - 28 Jan 2006 01:21 GMT

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

Signature

Leith Ross

Reply to this Message