Move selection down one cell
 

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

Move selection down one cell
 

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

Move selection down one cell
 

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

Move selection down one cell
 

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