Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove a constant from an excel spreadsheet?
I have a massive spreadsheet that I need to add formulas to but the cell from
which I need to contruct the formulas from has a contant and the formulas do not work how do I remove the constant? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove a constant from an excel spreadsheet?
First of all, you only need to post once--just be a little patient.
Secondly, can you give an example? This may not be exactly what you're looking for (since I'm not entirely clear what you're trying to do), but one way to remove a "constant" (e.g., a named cell or array) from your spreadsheet is to delete the Name (Using Insert | Name | Define and then deleting the unwanted Name). I'm not sure, though, what this will do to any existing formulas that use the name. "rugby1021" wrote: I have a massive spreadsheet that I need to add formulas to but the cell from which I need to contruct the formulas from has a contant and the formulas do not work how do I remove the constant? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove a constant from an excel spreadsheet?
Take a look at
Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm The actual instruction in the macro that clears the constants leaving the formulas of the inserted rows copied from above. Selection.Offset(1).Resize(vRows).EntireRow. _ SpecialCells(xlConstants).ClearContents --- 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 "rugby1021" wrote in message ... I have a massive spreadsheet that I need to add formulas to but the cell from which I need to contruct the formulas from has a contant and the formulas do not work how do I remove the constant? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
can you use cell references from Microsoft spreadsheet in excel ch | Excel Worksheet Functions | |||
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |