Forum Discussion
Formula has stopped working in Excel 2007
Worksheets("REPORTS").Range("S22").Formula = "=+'18 hole scores'!RC" & DateColumn . I have had this formula for 4 years and it worked fine. It puts a vaue like C27 into cell S22. I have not made a...
Hi George,
I guess it is related with R1C1 reference style.
Follow below path in your excel window
Excel Options -> Formulas -> Working with Formulas -> R1C1 reference style (uncheck it)
Regards,
DILIPandey