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

  • Thread starter Thread starter CousinExcel
  • Start date Start date
C

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
 
Hi

Try

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


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

CousinExcel said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top