A Format Macro on 1 sheet affects Macro processing on other Sheets until sine-out/sine-in

Hi guys,

My first Post.

I have been stumped by the way a Macro to format 1 sheet seems to affect other separate sheet Format Macros. I traced the issue down to the following code which seems to be setting some form of global parameter.
Yes, I know that there is probably a better way to do it but am keen to understand this anomaly (I have now removed this bit of code and all is fine now).


Any ideas ?
cheers Malc