Thread: Array MATCH function for VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Array MATCH function for VBA
Looks like a different situation. This one is one row.

--
Regards,
Tom Ogilvy

Dave Peterson wrote in message
...
And you have a couple of other responses to your first post.

"ExcelMonkey <" wrote:

I have a 2d VBA array. It is 1 row and 10 columns. It is filled with
dates. I want to return the position of a date variable within the
array. Similar to what I would do with a MATCH function in Excel.

How do you do this in VBA.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson



Reply With QuoteReply With Quote