Passively select cells in other worksheet

[rmweaver81]

I have written some code that runs about 400 lines of code in one worksheet, then 400 lines of code in another worksheet ("Calendar"), and finishes by returning to the first worksheet. When I run the code, it takes about a second to process. There is a flicker for about a quarter-second where you can see the "Calendar" worksheet. I am using slight deviations of the following code to switch between the worksheets:
Worksheets("Calendar").Cells(a,b).Select
With Selection
PerformAction
End With

Is there any way I can passively select those cells in the "Calendar" worksheet so that it doesn't become the active sheet? Is there a way I can suppress the script from flashing the "Calendar" sheet?

 

[BIGTONE559]

Where would you like the data to go and where is it currently?

 

[rmweaver81]

The two sheets are actually both two different types of calendars. The only input to these calendars is the year. Using the year, I calculate all of the holidays and place them on the calendars. The first calendar is used to track the balance of your time off as you use it throughout the year. The second calendar shows the entire year with special shading for 4-day weekends and 3-day work weeks that occur when holidays land on certain days. So basically, I'm not moving any data around. It just takes half a second for the script to create the first calendar and half a second to create the second one. I just don't want to see the flash between as it is processing.

 

[BIGTONE559]

i don't want to insult you. . . however have you tried using the application.screenupdating=false & True methods?

e.g.

application.screenupdating=false
'insert code here
application.screenupdating=true

 

[rmweaver81]

I'm new to programming, so no insult taken. I tried it out and it works perfectly! Thanks so much for your help!

 

[BIGTONE559]

glad i can help!