why doesn't vba have a min/max function?

[MetLife]

Why is it so difficult to just add this to the library?

 

[MetLife]

I just wrote a min function:

Function Min(a, b)
If a < b Then
Min = a
Else
Min = b
End If
End Function

Why can't microsoft add this?

 

[Fluff]

Why not just use the worksheetfunction?

 

[MetLife]

Because that it a horrible way to program in VBA.

 

[MetLife]

It slows down the program. Never use worksheet functions.

I blame microsoft. This is why people are using python instead of excel.

 

[Rick Rothstein]

It slows down the program. Never use worksheet functions.

I blame microsoft. This is why people are using python instead of excel.

Fluff meant for you to use the WorksheetFunction object which, as far as I know, is not all that slow (I use it all the time when I need Excel functionality that is not natively provided by VBA). In case you are not familiar with this object, you would call it like this...

WorksheetFunction.Min(...arg list...)

WorksheetFunction.Max(...arg list...)

 

[MetLife]

Fluff meant for you to use the WorksheetFunction object which, as far as I know, is not all that slow (I use it all the time when I need Excel functionality that is not natively provided by VBA). In case you are not familiar with this object, you would call it like this...

WorksheetFunction.Min(...arg list...)

WorksheetFunction.Max(...arg list...)

OK - I didn't know that.

I was always told that using worksheet functions was a big no no.

Thanks!

 

[Norie]

A big no no where/when exactly?

 

[MARK858]

Read this on my mobile at work and was confused as to why it was stated that WorkSheetFunction was slow and so after getting home dug out an old laptop and done a randbetween 1,400000 over 200000 rows and got FastExcel to time running the code below

Sub testmax()
Dim X As Long
X = Application.WorksheetFunction.Max(Range("A1:A200000"))
Debug.Print X
End Sub

The result was 7.43 milliseconds, that seems reasonably fast to me.

 

[MetLife]

A big no no where/when exactly?

application.worksheet.function

is slower than vba, considerably. That was my impression.

Maybe use another function other than min/max