Obviously the macro I suggested was untested, but it was intended
to be written as

Sub ClearConstants()
Selection.SpecialCells(xlConstants).ClearContents
end Sub