Use Match instead of Vlookup

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"iaguirre " wrote in message
...
I'm writing a VB script that reads from excel file....if I wanted to
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 the
value was found on......

please help!!!


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