Clear rows with vba

[DIMI]

Hello,
I want a macro to clear all contents from the rows if the column A the number is zero.
Thanks

[BobBridges]

That's easy, DIMI:

' ows is your worksheet object
' vr is the row you're examining
If ows.Cells(vr, 1).Value = 0 then ows.Rows(vr).ClearContents

[DIMI]

Thaks,but i don't know to write the code,could you write for me. Finally if i have zero in the second and forth row then the third i want to go up because would not space between from the rows.
Thanks

[BobBridges]

No, but if you're willing to take the time I'll teach you how. Then you'll be able to write your own macros any time you need one!


I've a Gmail account, robhbridges; contact me there and I'll get you started.