Ok, so this is driving me crazy, but I can't figure it out on my own. I need VBA to enter the SUMIF formula in a cell, but it keeps giving me the Run-time error '13': Type Mismatch on this line.
I know the ranges are ok, because before trying to change this I had just a normal SUM function in there and it worked perfectly.
How do I get VBA to put this in a cell for me?
This is what I'm trying that's giving me the error:
Range("B" & SumofPartsCell) = "=SUMIF(" & Range("B2", "B" & LastCellRowNumber) & "," & Chr(34) & ">2" & Chr(34) & ")"