passing defined name to vb
 

i have a large list of defined names which are various currency and
futures prices. is there a way to have a subroutine or function access
these values w/o having to pass each one as am argument. depending on
the value entered into a cell i want to access a different defined
name. for example, if a cell has EurGbp entered in it i want to access
the EUR and GBP named range from the function. I have seen examples of
how to access a single defined range fro ma formula but not a large and
growing list of names. thanks.


---
Message posted from http://www.ExcelForum.com/

passing defined name to vb
 

You have already received two replies to your previous post.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"bmeehan " wrote in message
...
i have a large list of defined names which are various currency and
futures prices. is there a way to have a subroutine or function access
these values w/o having to pass each one as am argument. depending on
the value entered into a cell i want to access a different defined
name. for example, if a cell has EurGbp entered in it i want to access
the EUR and GBP named range from the function. I have seen examples of
how to access a single defined range fro ma formula but not a large and
growing list of names. thanks.


---
Message posted from http://www.ExcelForum.com/