| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Hybrid Mode
