Relative References for macros

G

Grace

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?
 
F

Frank Kabel

Hi
you could also set this option for recording macros. Another way is
using offset. e.g.
activecell.offset(100,0).select
 
T

Tom Ogilvy

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

Grace

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

Tom Ogilvy

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.
 
G

Grace

Excellent!

Tom Ogilvy said:
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


macro
Click to expand...
 
Top