how do I pass myfunction(A2:A4) instead of myfunction("A2:A4")
myfunction( RANGE("A2:A4") )
"Andy B" wrote:
I want to define a function that takes a range in and operates on that range.
I want to use the normal Excel method of defining the range as (A2:A4), not
as a string. (If I use the string format, excel doesn't recalculate the
function when the data in the range changes)
when I define
function myfunction (inrange as Range) , the function call seems to fail.
|