Forum Discussion

George's avatar
George
Copper Contributor
Mar 19, 2017

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 any changes to the macro.

Now, the result in S22 is literally RC27. 

The problem is that the the Column value is not used - the literal value RC is used.

I have always allowed microsoft updates to be loaded for the OS and the other Microsoft products. I wonder if an update casues this?

Any suggestions? Thanks in advance.

George

Formulas & Functions
Need Help

2 Replies

  • dilipandey's avatar
    dilipandey
    Copper Contributor
    Mar 23, 2017

    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