I'm trying to get the value returned from the following MATCH

=MATCH("some name",sheet1!A1:A450,0)

it will return the row number that the match occured in.
this is the value I need.
I need to retrieve it from a macro.

I can;t seem to figure out the syntax to get that value.

if I simply use in a worksheet ...the formula will return what I need
but and dump in the current cell. I don't want to dump the result in a
cell but simply in my variable frommy macro..
how would I go about this?

thanks

PAbs


---
Message posted from http://www.ExcelForum.com/