pass named range address into variable
s1= [data1].Address
"okrob" wrote:
How can I create a string variable from a named range in a workbook?
ex:
Named range is at address: $D$11:$AB$11
Name is: data1
String I want passed into a variable is: "D11:AB11" or "$D$11:$AB$11"
Thanks
Rob
|