View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Marcotte A Marcotte A is offline
external usenet poster
 
Posts: 66
Default 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)