MIN/MAX question

[Mike]

How do you write a min/max formula in VB?

Within a macro I'm trying to get the minimum of two
numbers. I tried the following and got an error:

END = MIN(BEGROW +10, MAXROW)

Where BEGROW and MAXROW are calclutaed within the macro.

thanks

 

[Bob Phillips]

worksheetfunction.max(BEGROW+10,MAXROW)

 

[Guest]

Thank you so much!

-----Original Message-----
worksheetfunction.max(BEGROW+10,MAXROW)

--

HTH

RP




.

 

[Tom Ogilvy]

Function MyMin(A, B)
if A < B then
MyMin = A
else
MyMin = B
End if
End Function


You can add error checking and so forth.