VBA equivalent of MATCH()

What is the easiest way to get start and end row numbers for a range of
dates (eg 1st and 30th of a particular month) from column A? Using a
Match() spreadsheet formula works and gets me the start/end rows, but I
am curious about a VBA equivalent, especially as the data is coming from
a different workbook.

TIA,
R.

Use Application.WorksheetFunction.Match() in VBA

- Mangesh



"Mike Echo" <[email protected]> wrote in message
news:[email protected]...
> What is the easiest way to get start and end row numbers for a range of
> dates (eg 1st and 30th of a particular month) from column A? Using a
> Match() spreadsheet formula works and gets me the start/end rows, but I
> am curious about a VBA equivalent, especially as the data is coming from
> a different workbook.
>
> TIA,
> R.