Run VBA macro as if operating on earlier Excel version

[fbohlandt]

Hi all

I have a VBA macro that runs fine in Excel 365 but fails for earlier version of Excel. I have managed to identify the error but I need to run the code as if I was operating on Excel 2012 to check if my fix will work. Any ideas?

Thanks

 

[RoryA]

There is no Excel 2012, so that could be tricky.

You'll need to either get, or find someone with, the version you want to test against.

 

[fbohlandt]

There is no Excel 2012, so that could be tricky.

You'll need to either get, or find someone with, the version you want to test against.

I probably meant 2010. I am hearing that I have to run it on a computer with and older version. Thanks

 

[RoryA]

I assume this relates to this: VBA to copy formulas into worksheets - Application-defined error ?

 

[Fluff]

And also this VBA to copy formulas into worksheets - Application-defined error