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