Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone tell me why I am getting the above error in this function. It
only happens at a particular point in my code. It works fine until it get to that point. And I can't figure out what the mismatch is. Function msProjected(msDate As String, msStatus As String, currRow As Integer, MktRow As Integer, startRow As Integer, endRow As Integer) As Integer msProjected = Evaluate("=IF(AND(D" & currRow & "<0,D" & currRow & "<"""")," & _ "SUMPRODUCT(--('BO Download'!$B$" & startRow & ":$B$" & endRow & "=B" & MktRow & ")," & _ "--('BO Download'!$F$" & startRow & ":$F$" & endRow & "=C" & currRow & ")," & _ "--('BO Download'!$H$" & startRow & ":$H$" & endRow & "=""Selected"")," & _ "--('BO Download'!$" & msDate & "$" & startRow & ":$" & msDate & "$" & endRow & "TODAY())," & _ "--('BO Download'!$" & msStatus & "$" & startRow & ":$" & msStatus & "$" & endRow & "=""P"")),"""")") End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run time error 13 - type mismatch | Excel Programming | |||
Run Time Error 13- Type mismatch | Excel Programming | |||
run-time error 13: Type mismatch? | Excel Discussion (Misc queries) | |||
Run-Time error, type Mismatch | Excel Programming | |||
Run-time error 13, Type Mismatch | Excel Programming |