Relative References for macros
Excellent!
"Tom Ogilvy" wrote in message
...
Start recording and it should appear. If it doesn't, start recording,
then
go to View=Toolbars and select the stop recording toolbar. Now click the
stop button.
The toolbar should disappear, but should reappear if you start recording
again. Avoid clicking the little x in the upper right of the toolbar to
make it disappear - once you do, you will have to repeat the above to get
it
to appear again.
--
Regards,
Tom Ogilvy
"Grace" wrote in message
...
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?
|