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?
|