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


--
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

"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

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

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