Solved: Vba code to clear data cells only not those with formula

[BENSON]

Could some one help me with some code that will clear all the cells of a selected range that contain data but not cells in the same range that contain formulas

Thanks

[Bob Phillips]

Off the top

For Each cell In Selection

If Not cell.HasFormula Then

cell.ClearContents
End If
Next cell