Clearcontents of a range but keep formula in tact

[acsishere]

Dear Friends,

In my workbooks I am to clearcontents a range but to keep the formula in tact. What code would be helpful (using specialcells?).

Thanks in advance,

acsishere.

[VBA Noob]

Try something like

Please Login or Register  to view this content.

VBA Noob