| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parameters of SUMIF in VBA
msgbox application.sumif(worksheets("sheet1").range("e1:e 226"), "0", _
worksheets("sheet1").range("N1:N226")) Watch your ranges, too (226 or 224????). "mdalamers via OfficeKB.com" wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parameters of SUMIF in VBA
GREAT that did the trick!
PS sorry for my double post. I did not figure out how to delete a thread. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200703/1 |
| Reply |
| 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 | |||
Linear Mode
