PC Review


Reply
Thread Tools Rate Thread

active sheet is 'slow' to be active

 
 
Charlie
Guest
Posts: n/a
 
      31st Dec 2007
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?

 
Reply With Quote
 
 
 
 
Charlie
Guest
Posts: n/a
 
      31st Dec 2007
hmmm, I had some code in the controlsource of some controls that was causing
the problem...
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Data From Active Sheet to Closed Sheet on Network ryguy7272 Microsoft Excel Programming 4 3rd Jul 2008 08:44 PM
I need to sort an active sheet using the col of the active cell =?Utf-8?B?SGFtRmx5ZXI=?= Microsoft Excel Programming 3 6th Jun 2006 07:25 PM
Copy my active sheet to a new sheet and open with an input form Brad Withrow Microsoft Excel Programming 0 6th Apr 2006 03:56 AM
Copy from active sheet and paste into new sheet using info from cell in active Ingve Microsoft Excel Programming 3 23rd Jan 2006 09:57 PM
Can a a 2 node cluster support both active/active and active/passive configurations John H Microsoft Windows 2000 Advanced Server 0 19th Sep 2005 02:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:48 PM.