Type mismatch error with Chr(34)

[he4dhuntr]

Hi all,

I'm getting an error when I try to use a string with the Chr(34) in Excel 2007. I had a somewhat long string calculation giving me the error, but I tried to test it with a simple one. Here's the example code:

Sub Test()
    Dim a As String
    a = Chr(34) And "This is a test" And Chr(34)
    Sheets(1).Cells(1, 1).Value = a
End Sub

I get this error on the "a = ..." line:

Run-time error '13': Type mismatch

I've searched around, but for the life of me can't figure out what could be wrong.

Thanks for any help!

Cheers,

 

[MrKowz]

"And" is an operator for creating conditional statements. What you need is "&":

Sub Test()
    Dim a As String
    a = Chr(34) [B][COLOR=red]&[/COLOR][/B] "This is a test" [COLOR=red][B]&[/B][/COLOR] Chr(34)
    Sheets(1).Cells(1, 1).Value = a
End Sub

 

[he4dhuntr]

Wow... See I knew it would be something easy and stupid. THANKS A LOT

Much appreciated.

 

[MrKowz]

Wow... See I knew it would be something easy and stupid. THANKS A LOT

Much appreciated.

Not a problem, thank you for the feedback.

 

[Ruddles]

It's not stupid if you get something wrong the first time you try to do it.

Stupid would be if you did it wrong the second time!