Thread: Grabbing data from diff window w/o activating it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_92_] dominicb[_92_] is offline
external usenet poster
  
Posts: 1
Default Grabbing data from diff window w/o activating it

Good evening McManCSU

From what your post says, it is probably the screenupdating proces
that is slowing your macro down. Try using this trick to speed it up.
make the first line of your macro:

Application.ScreenUpdating=False

and the last line of your macro:

Application.ScreenUpdating=True

This should speed your routine up considerably.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39693

Reply With QuoteReply With Quote