Hi thank you for your input.


I'm opening the file>alt+f11>inserting a new module>saving and closing VBE>alt+f8>selecting macro name treat and running

It appears to work but only on the first month (march) and then errors with the following message:

Run-time error '1004':
Method 'Union' of object '_Global' failed

look forward to your response

Thanks