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)