#1
|
|||
|
|||
Clear rows with vba
Hello,
I want a macro to clear all contents from the rows if the column A the number is zero. Thanks |
#2
|
||||
|
||||
That's easy, DIMI:
Code:
' ows is your worksheet object ' vr is the row you're examining If ows.Cells(vr, 1).Value = 0 then ows.Rows(vr).ClearContents |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Clear browser history | Venom286 | Outlook | 0 | 04-08-2019 11:17 PM |
clear offline items | supertech | Outlook | 0 | 09-02-2015 01:46 AM |
Clear old RSS Feeds | eltonlaw | Outlook | 0 | 08-16-2012 07:32 PM |
Clear document | Jaymond Flurrie | Word VBA | 5 | 07-17-2011 05:07 PM |
Holidays--clear all? | markg2 | Outlook | 0 | 11-01-2009 05:57 AM |