Thread: next cell selection
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Robert Christie[_3_] Robert Christie[_3_] is offline
external usenet poster
  
Posts: 117
Default next cell selection
Hi Mas

Use the offset command

Activecell.Offset(1, 0).Activate (for 1 to the right)
Activecell.Offset(-1, 0).Activate (for 1 to the left)
Activecell.Offset(0, -1).Activate (for 1 up)
Activecell.Offset(0, 1).Activate (for 1 down)

HTH

Regards

Aussie Bob C.


"mas" wrote:

How can I select the next cell to the right, left, up or down?



Reply With QuoteReply With Quote