View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to insert: " into a string

double the double quotes:

"this string ""contains"" double quotes"

from the immediate window (to illustrate):

sStr = "this string ""contains"" double quotes"
? sStr
this string "contains" double quotes

--
Regards,
Tom Ogilvy

"Torben Laursen" wrote in message
...
Hi

How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004