I have tried to write code to clear Non-Formulas, but also do not want any tect cleared i.e I only want Values clear on sheet ("JNLS")
Kindly amend my code below
Kindly amend my code below
Code:
Sub ClearDataNonFormulas()
With Sheets("INLS")
With CreateObject("VBScript.RegExp")
On Error Resume Next
Sheets(1).UsedRange.SpecialCells(xlCellTypeConstants, 1).ClearContents
End With
End Sub