Filter two columns with "or" logic

[gsnidow]

Greetings all. I am trying to filter a worksheet where if there is a non-null value in either of two columns, display the entire row. I get complaints from users that the filtering required to come up with different scenarios is too complicated, so I am going to put a series of buttons across the top of the sheet. The below is an example of one where tow columns are both not blank...

Sub Filter_CXM_Bucket()

Dim WS As Worksheet
Set WS = ActiveWorkbook.ActiveSheet

WS.Select
'Check to make sure filter is on, in case user took it off
With Selection
If Not ActiveSheet.AutoFilterMode Then
ActiveSheet.Rows("4:4").AutoFilter
Else
'If it is on, take it off and put it back to reset
.AutoFilter
.AutoFilter
End If
'Apply not-blank criteria to columns 21 and 23
.AutoFilter Field:=21, Criteria1:="<>"
.AutoFilter Field:=23, Criteria1:="<>", Operator:=xlAnd
End With

End Sub

My thought was I could simply change the 'Operator:=xlAnd' to 'Operator:=xlOr', but it did not work. Is there any way to do this? I am using Excel 2003. Thank you.

Greg

[arthurbr]

Hi and welcome to the board


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[gsnidow]

Your post does not comply with Rule 3 of our Forum

I apologize for not properly tagging. Does that mean I should re-post this question?

Thank you.

[gsnidow]

Thank you Andrew. That is what I was thinking. At first I did not like it, but I can't think of a better way.

Greg

[arthurbr]

Andrew please do not answer a thread as long as the OP has not complied to a mod's request - Thx

[arthurbr]

I apologize for not properly tagging. Does that mean I should re-post this question?

Thank you.

If you click on the word " here" in my post you will find all the explanations needed

[Andrew-R]

Andrew please do not answer a thread as long as the OP has not complied to a mod's request - Thx

Sorry, I'm a newbie. If it makes things better I wasn't very much help.