The stop recording toolbar has a button that toggles relative and absolute
recording.

--
Regards,
Tom Ogilvy

"Grace" wrote in message
...
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?