I'm trying to extract certain data out of an array based on a "start date" and an "end date", what function in vb can i use to locate my first date in the array?
I have made an example workbook where i have 1 column of dates, 4 columns of values, a start date and an end date. I would like to write some code to extract the data from the values between these dates. I was thinking of doing some sort of do-while loop but i can't get it started because i dont know how to locate/match/find my start date in the array.
Bookmarks