AutoFilter in 2007

=?Utf-8?B?TWlyaQ==?=

Guest

Posts: n/a

19th Aug 2007

I run the same code In 2003 and 2007.
I used AutoFilter,
Actually, I got in 2007 select all includes blanks.
In 2003 I got all (but without blanks.)
It might be that the problem is not in 2007, and it only a configuration
issue, but I really don’t know where…
Please advice.
thanks
The code is:
cell.AutoFilter Field:=cell.Value, Criteria1:="<>"

--
Miri Tz.

« Need to trigger a warning, if any cell in a column exceeds two | lockout changes »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 autofilter change to 2003 autofilter functionality?	jonnybrovo815	Microsoft Excel Misc	1	19th Apr 2010 10:05 PM
2007 excel autofilter back to 2003 autofilter?	jonnybrovo815	Microsoft Excel Misc	3	19th Apr 2010 08:11 PM
2007 excel autofilter change back to 2003 autofilter?	jonnybrovo815	Microsoft Excel Misc	1	19th Apr 2010 05:53 PM
2007 Autofilter worse than 2003 Autofilter	=?Utf-8?B?anNreQ==?=	Microsoft Excel Misc	9	31st Oct 2007 12:14 AM
Autofilter 2007	jblake@citywire.co.uk	Microsoft Excel Misc	6	12th Dec 2006 07:48 PM