Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Computing a minimum in a user-defined function
Pardon me if I use the wrong words -- I'm a software guy, not a spreadsheet
guy. I am trying to write a function (macro?). Unfortunately, the function is choking on Min(a,b). Here's an example: (I invoke this by typing "=myfunc(+B12)" in a cell) function myfunc(a as currency) as currency Dim Result As Currency Dim x As Currency Result = 0 x = Min(100000, a) <== doesn't like this at run-time Result = Result + x * 0.07 .... end function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
User defined function | New Users to Excel | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |