HI All,
I have some code that is giving me the an error message. To speed up my macro I have this at the start
Some more code here to copy and manipulate data. followed by this:
I get a compile error message on the final line when asking to revert to automatic calculation, "Can't assign to read only propery". I'm not sure what I am doing wrong, can anyone help?
Thanks
Humate
I have some code that is giving me the an error message. To speed up my macro I have this at the start
Code:
With Application
.ScreenUpdating = False
.EnableEvents = False
.Calculation = xlCalculationManual
End With
Some more code here to copy and manipulate data. followed by this:
Code:
With Application
.DisplayFormulaBar = False
.DisplayStatusBar = False
.ScreenUpdating = True
.EnableEvents = True
.CalculationVersion = xlAutomatic
End With
I get a compile error message on the final line when asking to revert to automatic calculation, "Can't assign to read only propery". I'm not sure what I am doing wrong, can anyone help?
Thanks
Humate