"Next Year" function

  • Thread starter Thread starter Philip Carey
  • Start date Start date
P

Philip Carey

Is there a way to clear (delete) values from a worksheet
while retaining other information; i.e., can one derive
a "next year" worksheet in one, easy operation?
 
Is there a way to clear (delete) values from a worksheet
while retaining other information; i.e., can one derive
a "next year" worksheet in one, easy operation?
Click to expand...

What do you mean by "values"? Please be more specific.

Do you mean "anything numeric that is not a calculation"? If so, then you
can definitely write a VB macro to do so. (and it's really simple too)
 
you can use this macro
then just select the sells you want to clear and run the macro

Sub clearvalues()
Selection.SpecialCells(xlCellTypeConstants, 23).ClearContents
End Sub

Randall
 
Back
Top