Move selection down one cell

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
 
R

Ron de Bruin

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

ActiveCell.Offset(1).Select
 
G

GB

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top