View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default next cell selection

activecell.offset(i,j).select
i is the number of rows, +ve or -ve to move
j is the number of columns
so to select the cell to your left: activecell.offset(0,-1).select


"mas" wrote:

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