How do I create a macro with relative address?
 

How do I create a macro with relative reference in Excel 2003?

How do I create a macro with relative address?
 

All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
How do I create a macro with relative reference in Excel 2003?

How do I create a macro with relative address?
 

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.

"Bob Phillips" wrote:

All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
How do I create a macro with relative reference in Excel 2003?

How do I create a macro with relative address?
 

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.

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
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.

"Bob Phillips" wrote:

All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
How do I create a macro with relative reference in Excel 2003?

How do I create a macro with relative address?
 

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

How do I create a macro with relative address?
 

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:

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.

"Bob Phillips" wrote:

All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
How do I create a macro with relative reference in Excel 2003?

How do I create a macro with relative address?
 

There is still this option in my Excel 2003. It is on the Stop toolbar which
appears when you have OK the macro dialog.

--
__________________________________
HTH

Bob

"Pythagoras" wrote in message
...
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:

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.

"Bob Phillips" wrote:

All sorts of functions, OFFSET, RESIZE etc.

What exactly are you trying to do?

--
HTH

Bob Phillips

"Demokritos" wrote in message
...
How do I create a macro with relative reference in Excel 2003?