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

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

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

Hi

Try

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


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

"CousinExcel" wrote in message
...
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