probably application.screenupdating = false

Hi

Put in Application.ScreenUpdating = False
and Application.ScreenUpdating = True before and after your code e.g.

Sub DoThis()

Application.ScreenUpdating = False

'Your code here

Application.ScreenUpdating = True

End Sub



Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Thanks mate,

Worked like a charm.

Pantelis
"Spammastergrand" wrote in message
...
probably application.screenupdating = false