Thread: range.address ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alex J Alex J is offline
external usenet poster
 
Posts: 85
Default range.address ?


Mark,
Try something like:
xy = ThisWorkbook.Names("Test").RefersTo

it will give you "=Sheet1!$A$1:$A$4"

or .RefersToRange.Address to get "$A1:$A4"

Is this what you need?
Alex J


"Mark Kubicki" wrote in message
...
how do i get back the address of a named range ?
rngName: ='FirstSheet"!A1


do u know a good source for learning more about using named ranges; they

are
the ail of my existence!

thanks,
mark