Use "&" instead of "+" 'no quote marks
--
Jim Cone
Portland, Oregon USA




"GTyson2"
wrote in message ...
Hi All,

I get the type mismatch error on this line of code

TmpCB.Sheets("03-10").Cells(z, 2).Value =
OldCB.Sheets("032010").Cells(x, 2).Value + " - " +
OldCB.Sheets("032010").Cells(x, 3).Value


I know that cells(x,2) at this poin in the code is "check run" and
Cells(x,3) is "4277"
I'm sure it's because "check run" is text and "4277" is a number, but I
can't figure a way around it. I've tried doing .text instead of .value but it
still didn't work.

Can someone help me fix this?