Hi Sean,

Thanks for your suggestions.

Unfortunately the workbooks to be consolidated have been already been
distributed and it seems a bit of an overkill to either manually
change the code re the MsgBox or change the code re some sort of
automation.

However your Application.Visible has given me some ideas and l will
play around with that. I may just minimise the window while the macro
is running and then re-instate at the end of the code, although the
purpose of using ScreenUpdating was to gain those extra few seconds in
speed.

Once again thank you for your reponse. If you have any other ideas
they will be gratefully received.

Regards

Michael Beckinsale.