| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to filter first column only in range
what is the criteria? should be in format:
Selection.AutoFilter Field:=1, Criteria1:="<= 100" "Rea" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count nonblanks in column A when I filter by column B | Excel Worksheet Functions | |||
| use "Filter" to filter one range in many worksheets at a time | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| Transfering VBA Array Column Range to Excel Column Range | Excel Programming | |||
Threaded Mode
