min or max in a matrix

[Overkill32]

Hello,

In vba, is there a way to use "application.worksheetfunction.min()" to find the minimum of a vector Inside a matrix.
Exemple
Data(1 to 3, 1 to 20) as variant
Inside my Data(1,: ) i have dates. I would like to easily find the minimum date.

Thank you!

 

[Eric W]

Try:

MinData = WorksheetFunction.Min(WorksheetFunction.Index(data, 1, 0))

However, it also depends on how you enter the dates into the matrix. If you read the data from the worksheet (data(1,1)=Range("A1").Value), and it's formatted as a date, your data matrix will hold a text representation of the date. If it's formatted as General, you'll get the number, and the Min will work. Make sure that the values in data are really numbers.