VBA Clear Cell Contents

  • Thread starter Thread starter towl
  • Start date Start date
T

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?
 
Use Clearcontents instead of Clear

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Yes, Clear will clear everything including formats. If you want just text,
use ClearContents.
 
Back
Top