Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to rename a worksheet to 2007. I want to keep the formulas, but
clear the data so I can put in new information. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copy the entire worksheet (or workbook) using
Edit, Move or Copy, besure to sheck the Copy box, then on the new worksheet which you can rename, you can delete all of the Constant information in a selection. Select the entire sheet if you like, but it is unlikely that you'd want to remove row 1 and column 1 descriptive constants. You can select nontinguous areas if you like such as most of different columns. One way to protect some constant information is to change them to formulas For example: ="Description" Then invoke a macro such as the following. Sub Clear_Constants() 'D.McRitchie 2005-11-19 rightclick.htm - insrtrow.htm '-- provide for in rightclick cell, row, and column commandbars Dim rng As Range 'prevent expansion of a single cell selection Set rng = Intersect(Selection, Selection.SpecialCells(xlConstants)) If rng Is Nothing Then MsgBox "No constants in selection area(s) -- no removal" Else rng.ClearContents End If End Sub Directions to install and use the above macro in http://www.mvps.org/dmcritchie/excel....htm#havemacro The macro described above is part of some macros, that I invoke from the context menu. http://www.mvps.org/dmcritchie/excel/rightclick.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Fuddy321" wrote in message ... I am trying to rename a worksheet to 2007. I want to keep the formulas, but clear the data so I can put in new information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index and Match Formula | Excel Worksheet Functions | |||
need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |