Hi,

Sorry I took so long to get back to you, had other jobs that took priority!

Tried your revised code and getting the following:

Run-time error '1004':

PasteSpecial method of Range class failed
I'm stumped.....