Macro/ custom filter, criteria="abc" or blank
in [General]
|
Prev: Hours per week per resource
Next: Macro to Inserting Columns and then add column to horizontal total
From: CousinExcel on 17 Feb 2010 05:21 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
From: Roger Govier on 17 Feb 2010 07:04
Hi Try ActiveSheet.Range("$B$5:$L$20000").AutoFilter Field:=2, Criteria1:=FirmCriteria, Operator:=xlOr, Criteria2:="=" -- ------- Regards Roger Govier "CousinExcel" <CousinExcel(a)discussions.microsoft.com> wrote in message news:4F04294C-11A9-4F20-89C5-B42F2E9A5A34(a)microsoft.com... > 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 |