Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct in VBA
Thanks Bob, you are of course right, I forgot to define those
variables... I have made the suggested change now... However I am still getting Runtime error '13 Type mismatch... I think my problem is more fundamental. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct in VBA
Bob also changed your formulas (in case you missed that).
If you put the equivalent formula in cells on a that worksheet, do they all work ok? I'm wondering if you have errors in one of those ranges. DTM wrote: Thanks Bob, you are of course right, I forgot to define those variables... I have made the suggested change now... However I am still getting Runtime error '13 Type mismatch... I think my problem is more fundamental. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
SumProduct 3d | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions |