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:

Please Login or Register  to view this content.

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.

Your R1C1 notation is awry and without knowing which cell you're trying to reference it's hard to give an exact solution - assuming D3 is meant to be 1 second less then C4:

Please Login or Register  to view this content.

for a very brief overview of R1C1 see: http://www.excelforum.com/2171545-post2.html - this is just a post I made some time ago for another member - covers some basics.