Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AutoFilter from VBA
I want to show data rows based on 2 conditions using OR not AND.
I want to show a row if it has a value in Field 14 OR If it has no value in Field 12 AND a value in Field 16 I have some code that filters on one Field but I am having trouble making the OR working. Any way to do that ? Any help appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AutoFilter from VBA
Hi,
Am 24 Jun 2014 13:33:58 GMT schrieb Isis: I want to show data rows based on 2 conditions using OR not AND. I want to show a row if it has a value in Field 14 OR If it has no value in Field 12 AND a value in Field 16 try: Sub HideRows() Dim LRow As Long Dim rngC As Range With ActiveSheet LRow = .Cells(Rows.Count, 1).End(xlUp).Row For Each rngC In .Range("P2:P" & LRow) If Len(rngC) = 0 And Len(rngC.Offset(, -4)) 0 _ Or Len(rngC.Offset(, -2)) = 0 Then .Rows(rngC.Row).Hidden = True End If Next End With End Sub Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AutoFilter from VBA
On 24 Jun 2014 13:33:58 GMT, Isis wrote:
I want to show data rows based on 2 conditions using OR not AND. I want to show a row if it has a value in Field 14 OR If it has no value in Field 12 AND a value in Field 16 I have some code that filters on one Field but I am having trouble making the OR working. Any way to do that ? Any help appreciated. Thanks I don't think you can do that with AutoFilter. I think you have to use Advanced Filter. This will require setting up a criteria range on a worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |