jeudi 26 février 2015

EXCEL VBA: finding lowest value in column

i have tried to make select to pick column and find lowest value, but i dont know whats wrong:



mazas = Application.WorksheetFunction.Min(Sheets("maping").Range(Range("C3"), Range("C3").End(xlDown)).Select)


I think the biggest problem is that i dont know lenght of column it can gave 3 number or 3000 numbers, but it will always start at C3. Any ideas how to make it work?


Aucun commentaire:

Enregistrer un commentaire