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
|