Still looking for Help! Copying cell values from one open wo

mangoel · May 22nd, 2002, 11:37 AM

Hello All,

I have two workbooks open: WkBk1.xls and WkBk2.xls, with WkBk1.xls being the active window.

I need to copy the value in Cell(4,4) of WkBk2.xls to Cell(3,3) in the active workbook, WkBk1.xls using a Macro. How can I do this most efficiently without activating WkBk2.xls? I need to keep the focus on WkBk1.xls all the time.

I'd really appreciate any help on this. Thanks!

Manish

[ This Message was edited by: mangoel on 2002-05-22 11:05 ]

[ This Message was edited by: mangoel on 2002-05-28 10:51 ]

zzydhf · May 22nd, 2002, 11:59 AM

can you use a reference formula?
eg in wkbk1 d4 ='[wkbk2.xls]sheet1'!$c$3

zzydhf · May 22nd, 2002, 12:12 PM

Of couse you could just turn off the screen updating in your macro before getting the data - Application.ScreenUpdating = False

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 11:37 AM	#1
mangoel New Member Join Date: Apr 2002 Posts: 14	Hello All, I have two workbooks open: WkBk1.xls and WkBk2.xls, with WkBk1.xls being the active window. I need to copy the value in Cell(4,4) of WkBk2.xls to Cell(3,3) in the active workbook, WkBk1.xls using a Macro. How can I do this most efficiently without activating WkBk2.xls? I need to keep the focus on WkBk1.xls all the time. I'd really appreciate any help on this. Thanks! Manish [ This Message was edited by: mangoel on 2002-05-22 11:05 ] [ This Message was edited by: mangoel on 2002-05-28 10:51 ]

May 22nd, 2002, 11:59 AM	#2
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	can you use a reference formula? eg in wkbk1 d4 ='[wkbk2.xls]sheet1'!$c$3

May 22nd, 2002, 12:12 PM	#3
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	Of couse you could just turn off the screen updating in your macro before getting the data - Application.ScreenUpdating = False