|
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) |
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) |
| All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com