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 an
futures prices. is there a way to have a subroutine or function acces these values w/o having to pass each one as am argument. depending o the value entered into a cell i want to access a different define name. for example, if a cell has EurGbp entered in it i want to acces the EUR and GBP named range from the function. I have seen examples o how to access a single defined range fro ma formula but not a large an growing list of names. thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Passing a range to a user defined function | Excel Discussion (Misc queries) | |||
passing arrays to user defined functions | Excel Worksheet Functions | |||
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 |