How to jump to fisr empty row?

  • Thread starter Jan Nademlejnsky
  • Start date
J

Jan Nademlejnsky

I would like to use in my macro a feature to jump into the first empty row:

Let say I am in A3:

Sub JumpToEmpty()
Selection.End(xlDown).Select
????How to move from above to one cell down????
end sub

Thanks

Jan
 
C

Charles

Hi,

try

Sub JumpToEmpty()
Selection.End(xlDown).Offset(1,0).select <<<<<<
????How to move from above to one cell down????
end sub

Charle
 
J

Jan Nademlejnsky

I found it:

Sub JumpToEmpty()
ActiveCell.End(xlDown).Offset(1, 0).Select ' Goes down into first empty
cell
end sub

Jan
 
Top