And I bet you read VBA's help that said arrayformulas had to be passed in R1C1
reference style.
If your formula is easier to do in A1 reference style, try that in your code.
ps. Sometimes if you build the formula in the worksheet, then post that to the
newsgroup, it'll be easier for others to figure out what you're looking for.
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.
--
Dave Peterson