i see that this will copy a range from one sheet to another in the same
workbook
rng.Copy Destination:=Worksheets("Sheet3").Range("A1")

now, how to you adapt this if sheet3 is in another workbook that is open?

--


Gary

Try:
rng.Copy Destination:=Workbooks("Bk2.xls").Sheets("Sheet3") .Range("A1")

Hope this helps
Rowan

Gary Keramidas wrote:
i see that this will copy a range from one sheet to another in the same
workbook
rng.Copy Destination:=Worksheets("Sheet3").Range("A1")

now, how to you adapt this if sheet3 is in another workbook that is open?

think i got it. file2 is a variable i set

=Workbooks(File2).Worksheets("Sheet1").Range("A1")


--


Gary


"Gary Keramidas" wrote in message
...
i see that this will copy a range from one sheet to another in the same
workbook
rng.Copy Destination:=Worksheets("Sheet3").Range("A1")

now, how to you adapt this if sheet3 is in another workbook that is open?

--


Gary