| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch error
I have a macro that basically copies data from one sheet to another (within
the same workbook). When I run it, the second line below give me Error 13 - Type mismatch. All relavant cells are formatted exactly the same, and all my variables are singles. ReportSht.Cells(CurrRow, 4) = (MasterSht.Cells(i, 8) + _ MasterSht.Cells(i, 9)) * ReportSht.Cells(5, 3) ReportSht.Cells(CurrRow, 6) = (MasterSht.Cells(i, 10) + _ MasterSht.Cells(i, 11)) * ReportSht.Cells(5, 3) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
type mismatch error
Sorry for the double post... Please ignore this one. :(
"Marcotte A" wrote: I have a macro that basically copies data from one sheet to another (within the same workbook). When I run it, the second line below give me Error 13 - Type mismatch. All relavant cells are formatted exactly the same, and all my variables are singles. ReportSht.Cells(CurrRow, 4) = (MasterSht.Cells(i, 8) + _ MasterSht.Cells(i, 9)) * ReportSht.Cells(5, 3) ReportSht.Cells(CurrRow, 6) = (MasterSht.Cells(i, 10) + _ MasterSht.Cells(i, 11)) * ReportSht.Cells(5, 3) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
| Type Mismatch Error | Excel Programming | |||
| help with type mismatch error | Excel Programming | |||
| Type Mismatch Error Need Help | Excel Programming | |||
Linear Mode
