Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro - Delete Rows with specific text
Hi,
I want have the following types of table Total Inflow 82,437 25,921 26,294 27,272 28,455 Cheryl 0 0 0 0 0 Pension 0 0 0 0 0 Total Outflow 81,475 25,625 26,275 26,925 27,600 I want to delete the rows which includes all zeros - can someone please tell me the coding of doing this. Note- in the above table row starting with "cheryl" and "pension" should be deleted. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Delete Rows with specific text
hi,
Sub Macro1() For i = Range("A65536").End(xlUp).Row To 2 Step -1 If Range("A" & i) < "" And Application.Sum(Range("B" & i & ":IV" & i)) = 0 Then Rows(i).Delete Shift:=xlUp Next End Sub -- isabelle Le 2012-03-28 19:50, Umesh Banga a écrit : Hi, I want have the following types of table Total Inflow 82,437 25,921 26,294 27,272 28,455 Cheryl 0 0 0 0 0 Pension 0 0 0 0 0 Total Outflow 81,475 25,625 26,275 26,925 27,600 I want to delete the rows which includes all zeros - can someone please tell me the coding of doing this. Note- in the above table row starting with "cheryl" and "pension" should be deleted. |
#3
|
|||
|
|||
Thanks Isabelle, you are champion. It works perfectly well.
I was wondering if you have something like this for MS WORD. Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows with specific text | New Users to Excel | |||
Delete Rows Without Specific Text | Excel Worksheet Functions | |||
Delete Rows With Specific Text or Values | Excel Programming | |||
Delete Rows With Specific Text | Excel Programming | |||
Delete rows with specific text | Excel Programming |