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?