So I have this file with 60K rows. My data analyst people need to go through this and pick out about 30K rows. This occurs every few days.

They have 1 sheet with the 60K rows, and they have another with the 30k rows to pull out. I put them together in one workbook. then what I did was write a macro that took all the values in the column they are using for finding the correct rows (It's column A, an ID column) and put those values in an array. 

code:

```
        'in this code the active sheet is the one with the 30k rows to pull
        For i = 1 To numrows 
            killArray(index) = ActiveCell.Offset(i - 1, 0).value2 'did research and value2 is fastest
            index = index + 1

        Next

```

and then I used the autofilter:

```
'here the sheet with all 60k rows is active
Cells(1, IdCol).entireColumn.autofilter Field:=1, Criteria1:=Array(killArray), Operator:=xlFilterValues

```

So that then takes all 30k Id's puts them into an array, and filters the sheet with all rows using the array. Then the data guys can briefly look over it, and delete all of those rows.

now, they have decided they really want to use a custom format for the ID column. all id's are between 1 and 6 digits. so from 1 - 999999. the data guys have decided they like formatting it so that ALL id's are 6 digits, with leading 0's. so id 1 would be 000001. 

the problem is when I use .value to put the id's into the kill array, it gets the id without formatting. so id 000001 would be just 1. this would be fine except the autofilter doesnt work now. because id - 1, does not match id - 000001. I've done some checking, and I found I could use `killArray(index) = ActiveCell.Offset(i - 1, 0).text` but during the course of my research (and testing) I've discovered this is VERY slow. 

Is there a way to have autofilter ignore the formatting? I've done lots of reseach but I have only managed to find people having issues with dates. I don't have an issue with dates