[b]Help with VB filtering to suppress rows.[/b]

itviper

New Member
Joined
Feb 25, 2005
Messages
1
New here so for give me, but I have a spreadsheet that is driving me crazy. I have it setup and it has worked in the past, but something just is not working. I want columns K & L compared and if they both have zero values in a row, then I want that row suppressed. Here is the code:
Sub suppressallzeroes()
'
' suppressallzeroes Macro
' Macro recorded 4/18/01 by NRutledg
'
' Keyboard Shortcut: Ctrl+t
'
Rows("9:200").Select
Range("B9").Activate
Range("A9:V200").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("K201:L203"), Unique:=False
Range("C24").Select
End Sub

I have the Column Headings the same and the criteria offset in K202 and L203 as zeros. I have also tried putting the criteria in the same row, but still doesn't work, some rows are suppress even if they have a number <>0. I just want the 0 in both rows then suppress the row.

Any ideas would be greatly appreciated.
Thank you
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,923
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top