help with VBA

[madchemist]

I wrote a macro that accomplishes a bunch of task that I need to accomplish on a spreadsheet. The problem I am having is that some of the tasks require going to other worksheets.

I was wondering if it was possible to run this macro without having to watch excel do all of the functions? I don't want to watch it go to the other worksheets....is this possible?

 

[Norie]

You can turn off screen updating like this.

Application.ScreenUpdating = False

And turn it back on like this.

Application.ScreenUpdating = True

By the way are you using activate/select in the code?