Quotation Marks to Text via VBA

VBAnewbie · Aug 9th 2004

Hi,

How do I output something like "Hello on a cell?
I have used " "Hello " but it does not work.

Thanks,
Kim

**iwrk4dedpr** · Aug 9th 2004

You either must use the character method

Range("A1") = chr(34) & "Hello" & chr(34)

or you must user multiple quotations

Range("A1") = """"Hello""""

Change the last methd to Range("A1") = """Hello"""

firefytr · Aug 10th 2004

Also,

Code

[A1].Text = "Hello"

VBAnewbie · Aug 10th 2004

Thanks! Actually the triple quotation works great!

Kim

Participate now!