View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
okrob okrob is offline
external usenet poster
 
Posts: 142
Default pass named range address into variable

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