Finding Value in Excel Range
Try:
Application.WorksheetFunction.Match(What,Range("A1:A10),0)
Good luck.
TLXL
http://www.xydata.com
Quote:
> I have a range in excel (A1:A10) and I want to find in what row (relative
to
> the range) that a value would appear using VBA.
> --
> Chris