The best approach is not to use Select or Activate in your code so you
don't get the page swapping. The worksheet will remain on the sheet
that is selected when the macro is started. Also you wuold be able to
manually switch pages while the macro is running and watch the progress
of the macro without causing errors in the macro. the best practice is
not to use ActiveSheet or Active cell in you macro instead directly
refer to the cells.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165330

Microsoft Office Help