Stepping a progess bar through a subroutine

Hi, I’m very new to VBA and have been creating my first real macro for a real life situation at work.

It all seems to work how I want it to after several attempts at getting this far.

I managed to find a fantastic progress bar utility from these forums called KoolPrgBar (the guy that created this is a genius)

What I am trying to achieve is….

During one of the subroutine calls to save the workbook and clear the dreaded “you don’t have enough memory to complete this task” error (which seems to work for me) I want the progress bar to carry on increasing whilst running the sub routine but cant for the life of me work out how this can be done.

The following is the main macro that I run (please dont laugh, I did say this is my first attempt)….

Please Login or Register  to view this content.

Any ideas would be greatly appreciated, thanks