I can't find the "relative reference button" in the top menu. Is there
macro toolbar too? I can't find it at all, not sure if the "relativ
reference button" is in the toolbar.

HeyNow100 Wrote:
cooldyood wrote:

When recording macros, I always use the Ctrl+arrow combinations to
navigate across cells. But when I look at the code, there are always
hardcoded cell numbers. Is there a list of functions I can use for
Ctrl+arrow (or just the arrow) programatically?



When you record a macro the box that appears that lets you stop
recording also has another button next to it (the one on the right).
This button is a relative reference button. If you want all your
actions hardcoded then leave it alone. But if you want to record
Cntrl+arrow combinations to move around the cells, you should clic
the
relative referrence button.

You can click it more than once, to toggle between relative and
absolute references within the same macro

--
cooldyoo
-----------------------------------------------------------------------
cooldyood's Profile: http://www.excelforum.com/member.php...fo&userid=3561
View this thread: http://www.excelforum.com/showthread.php?threadid=55946