Thread: The " Character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janos Janos is offline
external usenet poster
 
Posts: 13
Default The " Character

thanks a bunch!

"Rick Rothstein" wrote:

Use two of them for each one you want in the String. For example, in this
statement...

MsgBox "AB""C""DE"

the C will appear with quote marks around it.

--
Rick (MVP - Excel)


"Janos" wrote in message
...
Hello All,

try as I might I'm stumped... How do I add a " character in a cell form
VBA?
As in I have a formula that looks something like this:
=Something(get data "12/02/2009" to "13/02/2009")

Everytime i try to assign it via ar ange.value= i run into problems (as it
terminates my statement early)

I know it must be possible, and i immagine it to be something trivial.
Yet... I'm stumped. Any ideas?

Thanks in advance