Referring to a Named Range

[jsnull]

Hi ... I have two spreadsheets...

test1.xls
test2.xls

test2.xls has a range of cells named Bld1

I want to be able to copy this range from test2.xls into test1.xls using VBA coding.

Please advise as to way to accomplish this?

Jim Null

http://www.jimnull.com

 

[rmikesmith]

VBA Code in test2.xls:

Range("Bld1").Copy Workbooks("test1.xls).Range("A1")

where Range("A1") can be changed to wherever you need.


Regards,
Mike

 

[jsnull]

Great ... thanx for the quick reply. What if the VBA code is running from test1.xls?

Jim Null

http://www.jimnull.com

 

[rmikesmith]

Try

Workbooks("test2.xls").Copy Range("A1")

Of course, in either example, both workbooks must be open.


Regards,
Mike