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
Hi Sunnie,
Goto File Menu Bar, Click to options
On Thu, Jul 12, 2012 at 7:13 PM, Sunnie sunni...@gmail.com 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 !
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 !
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
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
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 sunni...@gmail.com wrote:
I received a spreadsheet that is using the R1C1 reference formula. If I
