Change Clear to ClearContents...
--
HTH...

Jim Thomlinson


"towl" wrote:


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").C lear

End Sub

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


--
towl
------------------------------------------------------------------------
towl's Profile: http://www.excelforum.com/member.php...o&userid=26340
View this thread: http://www.excelforum.com/showthread...hreadid=477931