Macro/ custom filter, criteria="abc" or blank

[CousinExcel]

Hi,

I write in a macro
ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2,
Criteria1:=FirmCriteria
then I should add also
" or the firms which have blank as value".

I tried to do it manually and do "record macro".
But I could not succeed even manually.
In manual way, I I tried some tricks like "less than 1" etc.
but could not succeed.

Thanks and regards,

Cousin Excel

 

[Roger Govier]

Hi

Try

ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2,
Criteria1:=FirmCriteria, Operator:=xlOr, Criteria2:="="


--
-------
Regards
Roger Govier

Hi,

I write in a macro
ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2,
Criteria1:=FirmCriteria
then I should add also
" or the firms which have blank as value".

I tried to do it manually and do "record macro".
But I could not succeed even manually.
In manual way, I I tried some tricks like "less than 1" etc.
but could not succeed.

Thanks and regards,

Cousin Excel



__________ Information from ESET Smart Security, version of virus
signature database 4873 (20100217) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________

The message was checked by ESET Smart Security.

http://www.eset.com