Macro to Insert Changes the Formula
 

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
,
Dow wrote:

Why does it convert the range to F:(F)? And how can I fix it?

Macro to Insert Changes the Formula
 

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
,