ExcelBanter - MAX Function in VBE

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - MAX Function in VBE (https://www.excelbanter.com/excel-programming/442538-max-function-vbe.html)

pls123

MAX Function in VBE

hi all !
is there a way to use a MAX or MIN function in VBE ??
like this..TX !

if P5 max (P9;P10;P11) THEN
P5 = ZERO
END IF

Rick Rothstein

MAX Function in VBE

Not sure what P9, P10 and P11 are... variables or range references (the
semicolon delimiters are confusing)? Either way, this should work...

If P5 WorksheetFunction.Max(P9, P10, P11) Then

--
Rick (MVP - Excel)

"pls123" wrote in message
...
hi all !
is there a way to use a MAX or MIN function in VBE ??
like this..TX !

if P5 max (P9;P10;P11) THEN
P5 = ZERO
END IF

All times are GMT +1. The time now is 10:09 AM.