| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding multiple code dates for multiple item number | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| VBA + add multiple cells in code. | Excel Programming | |||
| Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Threaded Mode
