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.


Any help would be appreciated!

 

[konew1]

Will you please double check your question. I cant see where the red ) comes from
INDIRECT("Interface!R2C20:R27C27)")

 

[RoryA]

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