Worksheet clearing Macros?

[Guest]

Does anyone know how to write a Macro that, when activated, would clear all
the data NOT in a protected cell and leave the protected formulas alone? Or,
can this be done with regular Excel functions?

While we're at it, is it possible to use Conditional Formatting to clear
cell contents, again, leaving formulas in tact?

Thank you, everybody

Arlen

 

[Ron de Bruin]

Hi Arlen

Sub test()
On Error Resume Next
ActiveSheet.Cells.SpecialCells(xlCellTypeConstants).ClearContents
End Sub

Manual you can do this

F5
Special
Constants
Ok
Delete

 

[Gord Dibben]

Arlen

To address your second question....

No. CF cannot be used to clear cell contents.


Gord Dibben Excel MVP