View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Write " to a string

I think you mean

MyString = """"

Any time you want to embed quote marks in a quoted string they need to be
doubled up

Debug.Print "This is a ""quoted string"""

"Ian" wrote:

MyString ="""

--
Ian
--
"thyrmo" wrote in message
oups.com...
Hi

I have to write a single " (quotation mark) to a string but excel takes
it as an delimiter.
Anyone has a bright idea

Thanks in advance
Crister