Column stripped of formatting when running macro

I'm relatively new to VBA and am struggling to find a solution to this problem. I hope someone can help me out

I have a set of functions that are called to produce a user-defined report.
When running any of those report-building functions, the formatting is stripped from a range of cells in the ActiveSheet when I run it without breaks (see attached image showing cells without formatting)
FormattingStripped.JPG

It doesn't matter which sheet is active at the time, the formatting will be stripped in range("G9:G48") or range("F9:F48").
There are no references to this range in my script, and no references to "ActiveSheet".

The format stripping occurs at some point within the below section of code, but as mentioned previously, does not occur when I add breaks in.
I've tried commenting sections out to narrow it down to a specific part, but it doesn't seem to make any difference...

Please Login or Register  to view this content.

Has anyone else seen this before?
I'm totally lost on this one, would appreciate any insight

Thanks!

Anyone got any ideas on this one?
I've spent like a week trying to resolve this to no avail, and my presentation of this reporting system is in 4 days

Thanks very much in advance for any guidance provided

Hey MarvinP

Thanks for your quick response
That definitely makes sense... I had made the incorrect assumption that each event only begins after the previous event has completed
I'll read up on 'DoEvents' and will insert it after the more time consuming events at the beginning of my code.

I actually just wrote in a band-aid fix after my previous post/desperate-plea (see code below), whereby the report template formatting is painted over to the completed report. It works, but obviously adds to the run time which is not ideal.
Hopefully adding in some 'DoEvents' will mean I can remove the dirty fix :D

Please Login or Register  to view this content.

Thanks for helping a gal out, I'll post the result later today