can I clear a cell's contents and retain the formula in that cell?

[keithmct]

I have a range of cells on one input sheet that is automatically copied over to an order form. Formula in order form cells is =Home!E14 etc.
Now that we have 2 suppliers I need to remove (clear contents of that row or range) orders on the order form, column J, that starts with JPM, but clearing contents deletes the formula =Home!E14
any ideas?
I've looked at Go To Special which doesn't apply as far as I can tell.
I've used this code:

https://www.rondebruin.nl/win/s4/win001.htm

from Ron De Bruin which deletes the rows but then I'd have to add back rows with formulas in them to my order template for other things to work properly.
I'm pretty stumped at this stage.

 

[Jeffrey Mahoney]

If you clear the contents at Home!E14, then the formula will result in NULL.

So no, you can't clear the cell with a formula and have it retain the formula.

 

[keithmct]

I dont want to clear Home!E14, I want to clear the cell on the order form that looks at Home!E14 and duplicates the value there. Then I run some sort of code to remove the unwanted stuff from the order form sheet & the next time I use the spreadsheet it all has to go back to normal again.

 

[MARK858]

You can't clear a cell and retain a formula. By the sound of it you either need to use code to replace the formula or look at setting up the order form as a template.