View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Grace[_4_] Grace[_4_] is offline
external usenet poster
 
Posts: 106
Default Relative References for macros

I know I've seen it before but I cannot find this toolbar. Kindly tell me
how to access it.
Grace

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