VLOOKUP - location of value

  • Thread starter Thread starter iaguirre
  • Start date Start date
I

iaguirre

I'm writing a VB script that reads from excel file....if I wanted t
look up a value in a certain column I use this....
xlObj.WorksheetFunction.VLookup(trdNbr, xlObj.Range("K:K"), 1, False)

what I would like to know is how to find the excel row number that th
value was found on......

please help!!!:confused
 
Back
Top