Insert If formula in cell via macro?

**Macdave_19** · 10-26-2007, 09:52 AM

I was wondering how to insert the formula:

Please Login or Register  to view this content.

into a cell using code?

you see i have a clear form button that clears the cells and i just want the formula to remian in the cell for the next lot of data to be affected by it.

cheers everyone who reads this

Dave

**VBA Noob** · 10-26-2007, 09:56 AM

Try

Please Login or Register  to view this content.

VBA Noob

**Macdave_19** · 10-26-2007, 09:59 AM

My problem was that i didn't know that wrapping the quote marks in quote marks would work, i did actually think about trying it but now it works!! great.

cheers.