View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike M 91107 Mike M 91107 is offline
external usenet poster
 
Posts: 3
Default Passing a named range to a function

I have a named range called "Temperature" that is 1 x 10 vector.

I have a function x(ByVal value1 as double, Byval value2 as double) that I
need to run on all 10 temperatures.

When I go x(4,5) the function works.

When I go x(Temperature,5) the function gives #VALUE! error. My intent is
that the function will pull the Temperature value from the vector in the
column above it (or row beside it).

Little help?