View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Adam is offline
external usenet poster
 
Posts: 287
Default VBA + add multiple cells in code.

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..