| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA equivalent of MATCH()
Use Application.WorksheetFunction.Match() in VBA
- Mangesh "Mike Echo" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| equivalent for function , please for help | Excel Worksheet Functions | |||
| VBA equivalent for worksheet 'match'? | Excel Discussion (Misc queries) | |||
| VBA Equivalent Match/Index functions | Excel Programming | |||
| VBA Match Equivalent | Excel Programming | |||
| Equivalent of Match Functn in VBA | Excel Programming | |||
Linear Mode
