VBA Clear Cell Contents

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?

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

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"towl" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> towl
> ------------------------------------------------------------------------
> towl's Profile:
> http://www.excelforum.com/member.php...o&userid=26340
> View this thread: http://www.excelforum.com/showthread...hreadid=477931
>

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").Clear
>
> 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
>
>

Use Clearcontents instead of Clear

--

HTH

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


"towl" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> towl
> ------------------------------------------------------------------------
> towl's Profile:
http://www.excelforum.com/member.php...o&userid=26340
> View this thread: http://www.excelforum.com/showthread...hreadid=477931
>

Hi towl

Use ClearContents instead of Clear

--
Regards Ron de Bruin
http://www.rondebruin.nl


"towl" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> towl
> ------------------------------------------------------------------------
> towl's Profile: http://www.excelforum.com/member.php...o&userid=26340
> View this thread: http://www.excelforum.com/showthread...hreadid=477931
>