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

[MetLife]

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

 

[Fluff]

Have you seen what MARK858 said in post#9?
7 thousandths of a second is not very slow IMO

 

[MARK858]

Just to add the below link which although is doing a Match rather than a Max or Min it does do a speed comparison between worksheetfunction and other methods.

https://www.google.com/amp/s/fastex...heetfunction-match-performance-pros-and-cons/

 

[MetLife]

Does anyone know why the worksheet function: dd = WorksheetFunction.mod(45, 10)

does not work?

 

[RoryA]

VBA already has a Mod operator, so there is no WorksheetFunction equivalent. Note though that VBA Mod and the MOD function don't work the same way with negative numbers.

 

[MetLife]

I'm getting the error

GRADE = MOD(45, 10)

syntax error?

 

[RoryA]

It is an operator, not a function, so the syntax is:

GRADE = 45 MOD 10

 

[MetLife]

Never mind!

GRADE = 45 mod 10 works

 

[Rick Rothstein]

Never mind!

GRADE = 45 mod 10 works

If you wanted to use the worksheet's MOD function (as Rory pointed out, it works differently than VB's Mod operator), you could do so via the Evaluate function...

dd = Evaluate("MOD(45,10)")

Note that since the argument to the Evaluate function is a text string, you can concatenate text constants and variables together in order to make the call to the MOD function more dynamic. For example,

Number = 45
Divisor = 10
dd = Evaluate("MOD(" & Number & "," & Divisor & ")")