How do I create a macro with relative address?

  • Thread starter Thread starter Guest
  • Start date Start date
All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?
 
Thank you for your answer.
I'm trying to create by using the macro recorder a very simple macro, which
moves 2 lines down every time I press the short key.

In the Excel version for Windows 95 there had been an option for relative
references using the recorder (Tools/Create Macro/Use Relative References).
In Excel 2003 I cannot find this option, so that the recorder creates only
absolute references.
 
Sorry, I can't tell you how to overcome that change, but why don't you post
the code and we can help with that.
 
Demokritos

Do you mean something along these lines...

ActiveCell.FormulaR1C1 = "=RC[2]+R[2]C[2]"
ActiveCell.FormulaR1C1 = "=R[2]C+R[2]C[2]"

......although I prefer to use offset(rows,columns).

The flag you are after in Excel 2000 can be found in
Tools - Options - General Tab

Haven't got 2003 but perhaps it hasn't moved.

Donna
 
You´ve got a point!! Actually this facillity is avilable in Excel 2003, but
it has a way of comming and going which I can´t find out. I´m sure that it
can be turned of and on in some way. But how???????
:-)


"Demokritos" skrev:
 
There is still this option in my Excel 2003. It is on the Stop toolbar which
appears when you have OK the macro dialog.
 
You must log in or register to reply here.

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

How to force macros refer to ActiveWorkbook 2
create macro "merge selected cells"? 7
How to store relative cell values in variables & check it 2
Name a Table relative references 4
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
How do I turn on relative reference(?) in a macro (97ver had butto 1
New problem! All variables have to be defined? 5
Adding Outlook signature to email created by macro 3

Back
Top