K
kittronald
In a macro, how would you copy a defined name's contents from one
workbook to another ?
Book1.xlsb has a defined name "Name1" with a Refers To field of
"=Sheet1!$A$1:$A$3"
A1 = Orange
A2 = Apple
A3 = Pear
The contents of A1:A3 need to be copied to Sheet1!A1:A3 in Book2.xlsb.
kittronald
workbook to another ?
Book1.xlsb has a defined name "Name1" with a Refers To field of
"=Sheet1!$A$1:$A$3"
A1 = Orange
A2 = Apple
A3 = Pear
The contents of A1:A3 need to be copied to Sheet1!A1:A3 in Book2.xlsb.
kittronald