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

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

Is there a way to cycle through all named ranges? Something like:

For Each NamedRange in NamedRanges

tod

On Feb 21, 4:48*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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- Hide quoted text -

- Show quoted text -

todtown,

Debut.Print Range("Investments").Address

or

MsgBox Range("Investments").Address

Look up the Address property (as it applies to a range object) in XL's VBA
Help to see what all the arguments are, so you can adjust the output as
necessary.

HTH,

Conan




"todtown" wrote in message
...
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