VBA - Including a double quotation mark (") in a string

[bomvoo]

Is it possible to include a double quotation mark in a string variable?

If so how is it done, I mean, the following code is wrong, Is there an alternative way?

dim A as string

A= "worksheets("analysis")"

Thanks again !

Eduardo

 

[Norie]

Eduardo

Try this.

Dim A As String

A = "worksheets(""analysis"")"

MsgBox A

 

[Greg Truby]

Double the double-quote:

A= "worksheets(""analysis"")"