Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having a problem with MRound. At work we are using XL 2k3. I
can put "=mround(A1,.1)" into any worksheet cell and everything works as advertised. But when I use it in a macro "Result = Application.mround(Number, Mltplr)" I get the message "Object doesn't support this property or method". And yes, I have checked the "Analysis ToolPak" and "Analysis ToolPak - VBA" on the Add-Ins window. Any hints or suggestions as to what the problem is and a possible solution other than writing my own UDF to do the same thing? Thanks. -pb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MROUND | Excel Worksheet Functions | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
Mround | Excel Discussion (Misc queries) |