ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   AutoFilter in 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/154846-autofilter-2007-a.html)

Miri

AutoFilter in 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 dont know where€¦
Please advice.
thanks
The code is:
cell.AutoFilter Field:=cell.Value, Criteria1:="<"

--
Miri Tz.


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com