how to filter first column only in range

[Guest]

Hey eb
I need to filter column A only in some sheet.
I'm having trouble with setting the Field parameter in autofilter().

This is my code:

Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.workbooks.Open("D:\myExcel.xls")
Set xlWs = xlWb.Worksheets("myWorkSheet")
xlWs.Activate
xlWs.Range("A1:Z1").AutoFilter 1 =>filters all columns in sheet
xlWs.Range("A1:Z1").AutoFilter Field:=1 =>filter fails will error...

Any advice??

TIA
Rea

 

[Roman]

Hi Rea,
what about to use advanced filter?

 

[William Benson]

what is the criteria? should be in format:

Selection.AutoFilter Field:=1, Criteria1:="<= 100"