Relative Reference Help Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get relative reference to work while using my macros. The
help menu says there should be a pop-up toggle switch that allows me to
select between absolute and relative references. That button never appears.
Ideas, please?
 
The toggle doesn't appear when using the macros, it appears when recording
the macro (so that either relative or absolute references are used.)
 
Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP

I am trying to get relative reference to work while using my macros. The
help menu says there should be a pop-up toggle switch that allows me to
select between absolute and relative references. That button never appears.
Ideas, please?
Click to expand...

Gord Dibben MS Excel MVP
 
Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP

I am trying to get relative reference to work while using my macros. The
help menu says there should be a pop-up toggle switch that allows me to
select between absolute and relative references. That button never appears.
Ideas, please?
Click to expand...

Gord Dibben MS Excel MVP
 
Thanks a lot. I should have been more clear with my request. I did, in
fact, mean that the pop-up did not occur when creating the macro...nice catch.
 
Thanks a lot. I should have been more clear with my request. I did, in
fact, mean that the pop-up did not occur when creating the macro...nice catch.
 
Home run. Thanks a million...

Gord Dibben said:
Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP



Gord Dibben MS Excel MVP
Click to expand...
 
Home run. Thanks a million...

Gord Dibben said:
Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP



Gord Dibben MS Excel MVP
Click to expand...
 
I see that Gord correctly interpreted what you meant and provided the answer.
After I saw his reply, I figured that was more likely what you meant. Glad
he answered your question for you.
 
I see that Gord correctly interpreted what you meant and provided the answer.
After I saw his reply, I figured that was more likely what you meant. Glad
he answered your question for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet relative reference 3
Macro using relative references 5
Macro relative cell reference 5
Making relative references absolute 5
Macro Stop 3
How to write macro that selects relative locations 2
F4 key does not toggle relative/absolute cell references. 2
Relative, absolute & mixed references in many cells 11

Back
Top