Index Function Error, R1C1 References

[Felix_Dragonhammer]

Hello! I'm having a spot of difficulty, and after time spent researching the issue on the web and forum I've come up with no answers.

I have an INDIRECT function as follows:

INDIRECT("Interface!R2C"&(Code!R[-1]C+1)&":R27C27")

This resolves successfully to the following formula, as shown by the formula evaluator:

INDIRECT("Interface!R2C20:R27C27)")

The following evaluation results in a REF! error, and I'm not sure why. I am highly suspect of the syntax of the formula, particularly the quotes at the beginning and end. This is also my first attempt at using the R1C1 style of referencing in excel, so that might be a problem. Other than that, I have no idea.

 

[RickXL]

Hi,

Have you set the workbook Options to work with R1C1 style formulas?

If not, go to File-->Options-->Formulas-->Working with formulas-->R1C1 reference style and check the radiobutton.