Hello,

I would like to use a macro that will allow me to select the range A2 to
A65536 and every cells with a value that equals "0" must be cleared.

I don't wanna use the Find/Replace feature cause it removes the "0" from the
other cells and I really need them to remain intact. Here is an idea of what
I have:


A2: 4852035
A3: 8563201
A4: 4845625
A5: 4842562
....
A325: 4521023
A326: 4120001
A327: 7841036
A328: 0
A329: 0
A330: 0
....
A65534: 0
A65535: 0
A65536: 0


The cells having only a "0" in them will change all the time. One minute
it's from A328 to A65536 and the next, it's from A378 to A65536 (my file
updates itself from an SWL database.

I used the following form in my macro but my "0" stayed the

Range("A2:A65536").Select
If Cells.Select = 0 Then Selection.ClearContents

Any help would be great!!!