Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mis-match error
I have a macro that basically copies data from one worksheet to another
(within the same workbook). Below are two lines of code. The first executes, but the second gives me a Run Time Error 13 - Type mismatch. I've formatted all relevant cells 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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Error Type Mis Match Error 13 | Excel Programming | |||
Application.Match Type mismatch error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |