for some reason doing it your way added a second, but doing it as Jim
sugested shaved a second, not sure why.

"Keith74" wrote:

Hi

Try putting
Application.ScreenUpdating = False

at the start, and

Application.ScreenUpdating = True

just before the MsgBox, might help

hth

Keith