ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   active sheet is 'slow' to be active (https://www.excelbanter.com/excel-programming/403417-active-sheet-slow-active.html)

Charlie

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?


Charlie

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