Cheers Alan. Thanks for your help

I'm not really sure what "End With" means as I just Recorded a Macro to do this. The code was obviously created as a result of that.

I've copied both last months file and this months file into a spreadsheet. They are identical, so I don't know why they didn't work...

I will have a look at reducing the lines as you mentioned as well.

I'm just going to re-save the old file and try again after I change one or two bits of code to see if it works then.