View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do you include a quotation as part of a string ??

For a quote between quotes, use two quotes, like in
?" "" " + "Hello" + " "" "

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan Thompson" wrote in message ...
|I am trying to run this line of code which obviously doesn't work.
|
| MyString = " " " + "Hello" + " " "
| debug.print MyString
|
| what I am trying to end up with is
|
| "Hello" as my string QUOTES INCLUDED as part of the string.
| however every time I try to use them as part of a string VBA thinks that Im
| using them as a qualifer.
|
| Can anyone help me out with this one ?
|
| Thanks, Dan Thompson