Guess I don't understand what you're trying to do, then. Using the
single quotes creates a syntax error in the formula.

How would that give an R1C1 value to sRngLot?

Perhaps if you indicated what the AVERAGE formula should look like...?


In article . com,
wrote:

Well, I'm actually trying to give an R1C1 value to sRngLot and sRngCol
that can be used in the FormulaArray. Removing the single quotes does
not help.