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