Young_Money
New Member
- Joined
- Jul 8, 2011
- Messages
- 23
Hello.
I am trying to create a Sub that will delete the entire row in Excel with VBA if the number adds up to zero.
For example
0 0 0 0 0
1 3 0 1 3
0 2 0 1 4
2 0 0 2 5
I can use the SUM function to add it all up so I would get
0
8
7
9
Then, the entire first row would be deleted because the SUM = 0.
However, I have no clue how to do this.
Would anybody be able to give me any pointers or help me out with this?
Thanks.
I am trying to create a Sub that will delete the entire row in Excel with VBA if the number adds up to zero.
For example
0 0 0 0 0
1 3 0 1 3
0 2 0 1 4
2 0 0 2 5
I can use the SUM function to add it all up so I would get
0
8
7
9
Then, the entire first row would be deleted because the SUM = 0.
However, I have no clue how to do this.
Would anybody be able to give me any pointers or help me out with this?
Thanks.