| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can formulas in cells be made to remain if the data is deleted?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
