Hi,

Thanks for the code. Answer to your question which you've probably already worked out is yes all my data is in the first sheet of all the workbooks althougth they may not all necessarily be named as Sheet1.

Anyway, I tried running your ammended code but it returns the VB error 400 in a message box?

Thanks,

Lucas