I have a macro below to delete all rows there the debits and credits sum to zero
However, it also delete values that do not sum to zero
See link below
I have also posted on Macro to delete Rows where Values add up to zero In Col H (excelforum.com)
It would be appreciated if someone could kindly assist me
However, it also delete values that do not sum to zero
Code:
Sub DeleteRows_SummingtoZero()
Dim rw As Long, i As Long
rw = Cells(Rows.Count, 1).End(xlUp).Row
For i = rw To 2 Step -1
If Application.Sum(Cells(i, 9)) = 0 Then
Rows(i).Delete
End If
Next
End Sub
See link below
Dropbox - File Deleted - Simplify your life
www.dropbox.com
I have also posted on Macro to delete Rows where Values add up to zero In Col H (excelforum.com)
Macro to delete all rows that sum to zero
I have a macro below to delete all rows there the debits and credits sum to zero However, it also delete values that do not sum to zero Sub DeleteRows_SummingtoZero() Dim rw As Long, i As Long rw = Cells(Rows.Count, 1).End(xlUp).Row For i = rw To 2 Step -1 If Application.Sum(Cells(i...
www.mrexcel.com
It would be appreciated if someone could kindly assist me