Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range to a user defined function | Excel Discussion (Misc queries) | |||
passing arrays to user defined functions | Excel Worksheet Functions | |||
passing defined name to vb | Excel Programming | |||
passing a range to a user defined function using a form | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming |