ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autofilter Array (https://www.excelbanter.com/excel-programming/438549-autofilter-array.html)

brittonsm

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


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com