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

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

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.