Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another delete entire row
I have a spreadsheet imported from accounting software that shows all
customer activity in the last year by month.Column B through AA contains the dollar amounts paid by the customer. What I want to do is delete any rows that have zero balances in every column. If a row has any dollar amount over zero then I want to keep that row. I hope this makes sense. Someone please help. -- ______________________________ Thank you, Sean Artist/Production Manager Please visit us at www.oatesflag.com 502-267-8200 502-267-8246 fax |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another delete entire row
For i = Cells(Rows.Count,"A").End(xlUp).Row Step -1 If WorksheetFunction.CountIf(Rows(i & ":" & i), "<0") 0 Then Cells(i,"A").Entirerow.Delete EDnd If Next i -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Sean" wrote in message ... I have a spreadsheet imported from accounting software that shows all customer activity in the last year by month.Column B through AA contains the dollar amounts paid by the customer. What I want to do is delete any rows that have zero balances in every column. If a row has any dollar amount over zero then I want to keep that row. I hope this makes sense. Someone please help. -- ______________________________ Thank you, Sean Artist/Production Manager Please visit us at www.oatesflag.com 502-267-8200 502-267-8246 fax |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete an entire row | Excel Discussion (Misc queries) | |||
Delete an entire row if two cells...... | Excel Discussion (Misc queries) | |||
Delete entire row if | Excel Discussion (Misc queries) | |||
Delete entire row if A1,2,3... is empty | Excel Programming | |||
Delete Entire Row. | Excel Programming |