Clear Constants From a Range

Tutorial illustrating how to clear only constants from a range.

Use this VBA code to clear only the constants from a range and leave all formatting and formulas intact:

Range.SpecialCells(xlCellTypeConstants).Value = vbNullString

Change Range to the range reference to be edited.