Can formulas in cells be made to remain if the data is deleted?
 

Can formulas in cells be made to remain if the data is deleted?
 

Can you explain in a bit more detail what your question/problem is?

--
Kind regards,

Niek Otten

"wendyp" wrote in message
...

Can formulas in cells be made to remain if the data is deleted?
 

Hi Wendy,
See Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

To simply remove constants from a selection within a macro
Selection. SpecialCells(xlConstants).ClearContents

To remove constants manually from a selection
Edit, GoTo (Ctrl+G), Constans [you can pick what kind of constants]
Del key to clear

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"wendyp" wrote
(there was no question included, but see subject, . Yawn, very tiring)