active sheet is 'slow' to be active

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

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?
 
hmmm, I had some code in the controlsource of some controls that was causing
the problem...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to activate Sheet2? 5
Get Active Sheet 2
copy a range from active cell 6
Event Triggered in Wrong Sheet 4
Worksheet Activate event if only one sheet in book 3
Value from one sheet paste under same value on other sheet. 7
Help with code please 4
Shapes in 2010 1

Back
Top