Hi

You would need to use this in place of your macro, but change the file name
and sheet names to suit your case.

Regards

Roger Govier


shrek wrote:
Many thanks for that just one other question.

Do I set this up as a new seperate macro in the workbook or set it up
within the macro used to open the workbook.

Thanks