View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gabe gabe is offline
external usenet poster
 
Posts: 39
Default 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?