What about protecting all the other cells in the workbook (that you don't
want to clear), then selcting the entire worksheet and deleing?

"Gord Dibben" wrote:

Is the Total in A4 a formula you want to keep and delete the numbers in
A1:A3?

Simply select and delete A1:A3

Or select column A and F5SpecialConstantsOK

EditDelete

Record a macro whilst doing this if you want a macro.


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 13:10:01 -0700, Soth
wrote:

Hi -

I'm interested in clearing cell's number using a 'button', will macro
program work?
I'm not sure how to begin.

For Example:

A Press a 'Button' will clear all number
in column A.
$10
$20
$30
Total $60

Thanks,
Soth



.