active sheet is 'slow' to be active
Strange???
My code starts with wsA.Activate (wsA is set to sheet1) and then more code like that fills several cells with values, those values show up on the sheet that was active before I clicked run. It's like the code didn't have a chance to really make sheet1 active with the wsA.Activate cmd before it went ahead and pasted in some values for several cells??? Or am I missing something? |
active sheet is 'slow' to be active
hmmm, I had some code in the controlsource of some controls that was causing
the problem... |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com