Return a row
Posted on 2011-09-28
I have an Excel 2007 spreadsheet with, amongst other columns, a column of dates.
In VBA I need to find a particular date and then return its row reference.
I have googles this and the function Match is suggested.
But Match throws a compile error 'sub or function not defined'.
Here is just a bit of what I have tried:-
Dim rowref As string
Dim targetdate As Date
rowref = Match(targetdate, Range(A1, A100), 0)
I would have thought the rowref would have the row & column reference of the match.