Writing the character " into Cell

[frubeng]

Hi all,

I woul liked to have my cell contain the following
=myfun(A3 , "Date")

where myfun uses "Date" as a string. The problem is that writing this in my macro, treats the " char as the end of my string...
How do i solve this?

Thanks!! (i tried the \ like in java but it doesn seem to work. the most annoying thing about looking for help on this is that " isnt recognise as a character in google!!)

[Bob Phillips]

Show us what myFun does.

[frubeng]

Show us what myFun does.

It just takes the second input as string. My problem is that I am trying to say:
Workbooks("book1.xlsm").Worksheets("Sheet1").Cells(3, 1) = "=myfun(A3 , "Date")"

but of course, this treats it as:
"=myfun(A3 , " Date ")"
Is there a character i can put befroe the " to treat it as part of the string?

[Bob Phillips]

[vba]

Workbooks("book1.xlsm").Worksheets("Sheet1").Cells(3, 1) = "=myfun(A3 , ""Date"")"
[/vba]

[frubeng]

Great thanks!