dim str as string

str = range("Investments").address
msgbox str
--
HTH...

Jim Thomlinson


"todtown" wrote:

Here's an easy one for somebody. I have several named ranges on a
worksheet. Each named range represents a cell where I want to put the
results of a query. For example, if I have a range named "Investments"
somewhere on the sheet, and that range represents cell C25. What code
could I use to return the range address for the given named range?
Sounds easy just typing it, but I guess I just don't have the book
learnin' for such things. <g

tod