Move selection down one cell

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

Is there anything which only moves down one cell equivalent to
ActiveCell.End(xlDown)?

In other words, is there anything equivalent to End that only moves one
cell?

I appreciate that there loads of ways of doing this, for example:
ActiveCell.Offset(1,0).Select
ActiveCell.Range("A2").Select

However, these are a completely different syntax and with offset I always
have to stop and think whether I mean (1,0) or (0,1)!

Thanks

Geoff
 
You can use this if you think it is easier
It will use always the Active column

ActiveCell.Offset(1).Select
 
Ron de Bruin said:
You can use this if you think it is easier
It will use always the Active column

ActiveCell.Offset(1).Select
Click to expand...

Thanks, Ron. At least I don't have to remember 1,0 any more!
 
Back
Top