View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Arrow right code?

activecell.offset(0, 1).select

offsets (moves) the acctive cell 1 column to the right
--
HTH...

Jim Thomlinson


"Amil" wrote:

i am recording macros for an excel solution, however, i noticed that when I
arrow right, excel records an absolute reference (ie. Range("B32").Select) of
the row. This is not good because the number of rows will always be
different. How do I make the selection move to the next cell to the right
without absolute reference?