VBA equivalent of MATCH()

M

Mike Echo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 95 equivalent of modern events? 6
Pulling data from one workbook to another one using VBA 0
#name in match 3
Match, then Look Left 4 Columns, then Loop to End of Range 9
Saving a copied workbook - 2 questions 6
VBA equivalent of findstr 2
VBA equivalent of Javascript continue 2
VBA CreateNames (ignores last 5 rows?) 6

Top