Finding a value in a worksheet via VBA

Finding a value in a worksheet via VBA

Hi,

I'm trying to find a string (ex. "Smith, Joe") in a column ("A") in a sheet.

First, it appears that Match is the function I should use, is this correct?

If so, I cannot get it to work. Here is the code
   
   dim x as long
   msgbox (x)
   x = worksheetfunction.MATCH("Rabbit", WorkSheet("KeithQuoteData").Range("A1:A50"), 0)

I'd appreciate any help with the Match function or a better way to search for a string and return its location.

Thanks,
Dennis