Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a macro with relative address?
How do I create a macro with relative reference in Excel 2003?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a macro for my email address? | Excel Discussion (Misc queries) | |||
How write Macro to save worksheet to a RELATIVE address | Excel Discussion (Misc queries) | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
what is difference between absolute address and relative address? | Excel Discussion (Misc queries) | |||
Relative address equations | Excel Programming |