soulman247
New Member
- Joined
- Dec 22, 2011
- Messages
- 13
Hello,
I am using the following code to clear the contents of a cell, as part of a form reset, but I would like to preserve a formula I have now added to this cell.
.Range("H14").Interior.Color = xlNone
.Range("H14").Value = ""
I've tried a variety of things based on a suggestion I found on the forum - below - but can't get the code compilation correct.
Selection.SpecialCells(xlCellTypeConstants, 23).ClearContents
Any guidance would be massively appreciated. Thank you
I am using the following code to clear the contents of a cell, as part of a form reset, but I would like to preserve a formula I have now added to this cell.
.Range("H14").Interior.Color = xlNone
.Range("H14").Value = ""
I've tried a variety of things based on a suggestion I found on the forum - below - but can't get the code compilation correct.
Selection.SpecialCells(xlCellTypeConstants, 23).ClearContents
Any guidance would be massively appreciated. Thank you