Grabbing data from diff window w/o activating it
 

I would like to grab data from one window's sheet and put it in another
window. Problem is that I do I do several thousand times. Is there a
way to do it with having to activate the window #1 copy, activate
window #2 paste, but rather go into window 1 and move data to window 2?
It would save a ton of time to visually show each window popping up...

I tried something like this:


Code:
--------------------
dim x as string
x = x & windows("blah").sheets("sheet").Range("A1").value
--------------------


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=396938

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