View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB[_3_] GB[_3_] is offline
external usenet poster
 
Posts: 70
Default 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