ActiveCell(2)
would also work (in xl97 and later).
--
Regards,
Tom Ogilvy
Ron de Bruin wrote in message
...
You can use this if you think it is easier
It will use always the Active column
ActiveCell.Offset(1).Select
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"GB" wrote in message
...
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