I knew it would be something obvious. I feel like an idiot now.

Thank you very much for your help.



On Feb 6, 9:07*am, JE McGimpsey wrote:
Because by using the .FormulaR1C1 property, you've told VBA that the
range references will be of R1C1 form, not A1 form.

You can either use .Formula, or you can modify the ranges to R1C1

In article
,