Re: $$Excel-Macros$$ Cell adddress changed automatically

2010-02-17 Thread Balachander S
Paul Thanks for the prompt response.It worked and so do my macros Baloo On Tue, Feb 16, 2010 at 10:47 PM, Paul Schreiner wrote: > What version of Excel are you using? > What you are referring to is called using "R1C1 reference style". > In Excel2007 it is found under Excel Options -> Formulas >

Re: $$Excel-Macros$$ Cell adddress changed automatically

2010-02-16 Thread Paul Schreiner
What version of Excel are you using? What you are referring to is called using "R1C1 reference style". In Excel2007 it is found under Excel Options -> Formulas and under the "Working with formulas" heading. I'm not sure where to find it in older versions of Excel (perhaps you can searc for R1C1)