VBA Compatibility Problem 2003 to 2016

[billpq]

I have a macro that I’ve been using in Excel 2003 for years that works flawlessly. It creates a formula using R1C1 references and copies it then pastes it to other cells, etc.

On a new computer with Excel 2016 the formula comes out wrong as it doesn’t seem to interpret the R1C1 the same way as 2003.

Any suggestions? I went into Options and enabled R1C1 but that didn’t fix it.

Is there a VBA setting I’m missing?
Is there a better way to convert the script from 2003 to 2016 than just opening it, running the compatibility mode feature and then re-opening it as a .xlsm?
Are there other compatibilty issues between 2003 & 2016 that I can find a list of for other files I use frequently?

Thanks for any help!

 

[billpq]

Ahhh... that makes perfect sense about RC13 being valid either way. Again, I really appreciate the help!