I am pulling my hair out in big clumps trying to resolve this. When the macro fails and I get the error message in the Title block it highlights the following line;
Range("VERSION").FormulaR1C1 = TempVersion
I assume that I've not properly defined something but I'm wearing my Captain ADHD hat...