Hi Chris,
The first thing I notice is that there's no worksheet specified for the first series of "ClearContents" operations - this means that the macro will begin clearing in whatever worksheet is selected at the time you run the macro. This sort of thing often happens when you use a macro which has been recorded, because you don't think of selecting the first sheet DURING the macro recoding operation.
So, the very first command in your VBA routine should be like this:
BUT make sure you replace "Monthly Totals" with the actual name of the first worksheet on which you wish to operate.
Try this & please let me know how you get on.
Best regards,
Greg M
Bookmarks