Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Array
I can't find the answer to this can someone help me finish this code -
I need to set the autofilter to the values in the Array - Using XL2007 With Worksheets("Ariba Export") UpLoadArray = .Range("A2", .Range("A" & Rows.Count).End (xlUp)).Value End With ActiveCell.SpecialCells(xlLastCell).Select End_Cell = ActiveCell.Row End_Column = ActiveCell.Column Range("A1").Select Range("A1", ActiveCell.Offset(End_Cell - 1, End_Column - 1)).AutoFilter ActiveSheet.Range("A1", ActiveCell.Offset(End_Cell - 1, End_Column - 1)).AutoFilter Field:=6, Criteria1:=ArrayUpLoadArray, Operator:=xlFilterValues |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array-to-row autofilter issue | Excel Programming | |||
get value from last row of an autofilter array | Excel Worksheet Functions | |||
Autofilter multiple criteria using array | Excel Programming | |||
Array formula with AutoFilter | Excel Programming |