View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bmeehan bmeehan is offline
external usenet poster
 
Posts: 1
Default 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