Relative References for macros
Hi
you could also set this option for recording macros. Another way is
using offset. e.g.
activecell.offset(100,0).select
--
Regards
Frank Kabel
Frankfurt, Germany
Grace wrote:
I seem to need a lot of help for coding when I can't use record macro
to figure out certain things, particularly things that involve
relative movements within a worksheet. Somewhere in my very distant
past, perhaps with LOTUS, I seem to recall there was a way to record
so that it would record the relative changes (like going down 100
rows) rather than going from row 4 to 104. Is there still such a
capability with EXCEL macros. If so, will it do the things I am
thinking of?
|