Type Mismatch

[GTyson2]

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?

 

[Jim Cone]

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




"GTyson2" <[email protected]>
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?

 

[Dave Peterson]

It looks like you're trying to build a string.

Try using &'s instead of +'s.

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

 

[Barb Reinhardt]

Have you tried replacing + with & ?