VBA + add multiple cells in code.
Stab in the dark here but as a guess one of the cell addresses you are
referencing is not a number, but rather is text of some sort. Excel does not
understand what you want to do when you try to add a number to a text string
and you get a type mismatch error...
HTH
"Adam" wrote:
I keep getting a data type mismatch. What am i doing wrong on the addition??
If Worksheets("Int Project").Cells(Row, 186) 0 Then Worksheets("Int
Quote").Cells(Row, 109) = "Doors & Frames - " & "Apply " &
Round(Worksheets("Int Project").Cells(Row, 184), 0) & " Coats " & "- Time: ("
& (Worksheets("Int Project").Cells(Row, 72).Value + Worksheets("Int
Project").Cells(Row, 78).Value) & " hours)" & " " &
Worksheets("Int Project").Cells(Row, 186) & " Gallons of ____________"
'Average Doors and Frames
Thanks..
|