Using VBA to enter a formula into a cell - conflict in programming terms and formula

Hi everyone,

I wonder if someone could help me please?

Part of the procedure I am writing needs a formula to be entered in some cells. The formula I want in the cells is:

Cells(3, 4).FormulaR1C1 = "=rc[1,-1]-("0:0:01")"

The cell I am pointing to is a time and I want to subtract one second from that time. This is all fine and works fine when I type it manually in. Likewise I have no problems entering formulas but in this instance (and many others) the formula contains " which VBA recognises as part of the programming, not part of the formula. This also happens with :, is there a way around this problem that anyone knows of?

Many thanks.