worksheetfunction.max(BEGROW+10,MAXROW)

--

HTH

RP

"Mike" wrote in message
...
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