Tags: cell, constant, contant, contruct, excel, formulas, massive, microsoft, msdn, software, spreadsheet

How do I remove a constant from an excel spreadsheet?

On Microsoft » Microsoft Excel

2,102 words with 2 Comments; publish: Thu, 22 May 2008 19:08:00 GMT; (30678.13, « »)

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?

All Comments

Leave a comment...

  • 2 Comments
    • 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?

      #1; Thu, 22 May 2008 19:09:00 GMT
    • 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" <rugby1021.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:EF506131-21D1-46E0-88BA-DB62959C9473.excel.todaysummary.com.microsoft.com...

      > 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; Thu, 22 May 2008 19:10:00 GMT