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
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