View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gleam Gleam is offline
external usenet poster
 
Posts: 87
Default 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