Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2013, 01:06 PM
coxjamd coxjamd is offline AutoFilter Criteria3 Windows XP AutoFilter Criteria3 Office 2010 32bit
Novice
AutoFilter Criteria3
 
Join Date: Jan 2012
Posts: 6
coxjamd is on a distinguished road
Default AutoFilter Criteria3

I am trying to run an Autofilter using multiple criteria. I have no issue with Criteria2, but when I try to enter AutoFilter Criteria3 I end up with a runtime error.

Code that works for 2:
Selection.AutoFilter Field:=1, Criteria1:=">03-003", Operator:=xlAnd, _
Criteria2:="<>*x*"

Trying to enter for 3:
Selection.AutoFilter Field:=1, Criteria1:=">03-003", Operator:=xlAnd, _
Criteria2:="<>*x*", Operator:=xlAnd, Criteria3:="<>Pending"



Am I missing something simple?

Last edited by coxjamd; 01-17-2013 at 01:15 PM. Reason: typo for Criteria3
Reply With Quote
 

Tags
autofilter, criteria3



Other Forums: Access Forums

All times are GMT -7. The time now is 09:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft