VBA Clear Cell Contents

[towl]

I have written a simple Macro to clear a cell range, however it clears
all the formats as well as the text.

All I am after is the text deleting, but not eh cell formats, as some
are in % and some currency, to drive later formulas.

The code I have is

Sub Clear_Form()
Worksheets("selectordump").Range("a2:c2,b8:b12").Clear

End Sub

anyone know what I should do just to erase the text?

 

[Bob Phillips]

Use Clearcontents instead of Clear

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Zack Barresse]

Yes, Clear will clear everything including formats. If you want just text,
use ClearContents.

 

[Guest]

Change Clear to ClearContents...

 

[Ron de Bruin]

Hi towl

Use ClearContents instead of Clear