field:=1, Criteria1:="="

for blanks

field:=1, Criteria:="<"

for non-blanks.

--
Regards,
Tom Ogilvy




"mogens" wrote:

Chip Pearson wrote:
Where are you putting the code? It should be in a regular code
module, NOT the ThisWorkbook code module or a sheet module.


Thanks Chip - that explained the error.

I am trying to find a way to see how to qualify for instance how to
select only records with "blanks". This formula didn't give much of an
explanation though.

A shame that you are not able to switch between different criteria for
an autofilter as the advanced filter is a mystery to me (doesn's seem to
update automatically and I can't find somewhere with an easy overview of
criteria definitions) :-(