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