View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
McManCSU[_28_] McManCSU[_28_] is offline
external usenet poster
 
Posts: 1
Default 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