Hi Sunnie,
Goto File Menu Bar, Click to options
On Thu, Jul 12, 2012 at 7:13 PM, Sunnie wrote:
> I received a spreadsheet that is using the R1C1 reference formula. If I
> turn turn off the R1C1 to apply the A1 reference will that then change how
> the formula works?
>
> Thanks !
>
> --
> FORU
Dear Sunnie
Uncheck R1c1 check box from file-Options-Formula.
Hope it should work
Regards,
Gawli Anil
On Fri, Jul 13, 2012 at 8:20 AM, Susan 1 <> wrote:
> Attached are the two spreadsheets. The one titled Aug2012 has the R1C1
> formula, the file ETS2011, is the data template for this year's en
Sunnie, Can you share spreadsheet with group as a sample.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 12, 2012 at 7:13 PM, Sunnie wrote:
> I received a spreadsheet that is using the R1C1 reference formula. If I
> turn turn off the R
Try it
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Sunnie
Sent: Thursday, July 12, 2012 8:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ R1C1
I received a spreadsheet that is using the R1C1 reference formula. If I turn
turn off the
