type mismatch error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type mis-match error 2
Run-time error 13: Type mismatch 9
Concatenating two spreadsheets by a column 1
type mismatch error 2
Not getting "argument type mismatch" 4
Sheet to sheet code Type Mismatch 6
MSGBOX Run-time Error '13': Type mismatch 6
Type Mismatch 1

Back
Top