| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parameters of SUMIF in VBA
Please help me.
I try to run a SUMIF worksheet function from my VBA code. Basically this is the troublesome line. MsgBox Application.WorksheetFunction.SumIf("$E$1:$E$226", "0", "$N$1:$N$224") When I run it, Excel gives me a compile error, type mismatch, highlighted on: "$E$1:$E$226" What am I doing wrong? Regards, Michiel. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200703/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too few parameters | Excel Discussion (Misc queries) | |||
| Excel problem - sumif with multiple parameters | Excel Worksheet Functions | |||
| Too few parameters | Excel Discussion (Misc queries) | |||
| too few parameters | Excel Discussion (Misc queries) | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
