Using AutoFilter from VBA

Posted to microsoft.public.excel.misc

Isis[_2_]

external usenet poster

Posts: 51

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 autofilter change to 2003 autofilter functionality?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 10:05 PM
2007 excel autofilter back to 2003 autofilter?	jonnybrovo815	Excel Discussion (Misc queries)	3	April 19th 10 08:11 PM
2007 excel autofilter change back to 2003 autofilter?	jonnybrovo815	Excel Discussion (Misc queries)	1	April 19th 10 05:53 PM
2007 Autofilter worse than 2003 Autofilter	jsky	Excel Discussion (Misc queries)	9	October 31st 07 12:14 AM
How to Sort within AutoFilter with Protection on (and AutoFilter .	giblon	Excel Discussion (Misc queries)	1	February 16th 06 12:23 PM

All times are GMT +1. The time now is 08:03 AM.

Menu

About Us