Minimise the workbook or insert a blank sheet and activate it before starting the rest of your macro. Also:
Application.ScreenUpdating = False
will suppress screen activity. Set it back to True at the end.
Application.ScreenUpdating = False
will suppress screen activity. Set it back to True at the end.
No comments:
Post a Comment