View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Grace[_4_] Grace[_4_] is offline
external usenet poster
 
Posts: 106
Default 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?