Hi Janos,

How about CHR(34) & "2/19/2009" in VBA

or CHAR(34) & "2/19'2009" using worksheet functions.

Mike



"Janos" wrote:

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