When I used to click-on or select the record macro button, a small icon
used to pop-up that allowed me to select whether I wanted absolute or
relative reference. For some reason, the icon does not display anymore,
and I don't know how to record a macro in relative; it automatically
records in absolute.

I needed a macro to work using the two cells next to wherever the
cursor was placed, and I ended up having to edit the recorded macro by
replacing the absolute cell references with "-with selection-" and
"-end with-". This worked, even if it is not the proper way to get
relative reference.

How can I (again) choose whether a macro is recorded using relative or
absolute reference?

Thanks!

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=510161