hi there,
i'm writing a function where it takes a named range as an argument. With this range it has a number of values and i've managed to get the smallest value (which is what i want by using this:
myVal = application.worksheetfunction.small(myNamedRng,1)
so far so good. What i then want to do is find the row postion of this value in the named range.
Any ideas at all??
thank you!
e
i'm writing a function where it takes a named range as an argument. With this range it has a number of values and i've managed to get the smallest value (which is what i want by using this:
myVal = application.worksheetfunction.small(myNamedRng,1)
so far so good. What i then want to do is find the row postion of this value in the named range.
Any ideas at all??
thank you!
e