| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif from VBA Type mismatch
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...tions/200703/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run-time 13 Type mismatch | Excel Discussion (Misc queries) | |||
| Type Mismatch Error | Excel Discussion (Misc queries) | |||
| type mismatch--how to fix | Excel Discussion (Misc queries) | |||
| Type mismatch on LastRow | Excel Discussion (Misc queries) | |||
| Why type mismatch - R/T error 13 | Excel Discussion (Misc queries) | |||
Threaded Mode
