search for Value between Dates specified

Originally Posted by ShadowOfTheBeas

Hi Can anyone tell me how to find the minimum value in a table between two dates specified in cells ( e.g D1 and D2) of the current Sheet:

Could minValue occur more than once?
If it can you may need to use the Find method to loop through all occurrences of minValue and check if it's between minDate and maxDate.

Originally Posted by ShadowOfTheBeas

also when i get the minValue how do i set the Cell where i find this minvalue to be the activeCell?

since i have the minvalue as 'answer' i am not sure how to set the Cell where i find the value of the 'answer' variable to be the active Cell

Something like this:

Please Login or Register  to view this content.

But you don't need to activate a cell to work with it, instead of the above use

Please Login or Register  to view this content.