View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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