Ok, I need to do what should be a fairly simple autofilter operation, but I'm having a bunch of truoble getting it to work. What I really want is to filter column 1 such that ( (x>=2000 And x<3000) Or x="*U*" ). I've read that excel can only take two criteria at a time to the autofilter command, so I've been trying to use an extra column to make it work, but I am still having some problems with the sorting. Heres what I am working on:
With Sheets("Sheet1")
            For row = 2 To 5000 Step 1
                If .Cells(row, 1) < 3000 And .Cells(row, 2) >= 2000 Then
                    .Cells(row, 63) = 1
                End If
            Next row
        .range("A1").AutoFilter field:=63, Criteria1:="=1"
        .range("A1").AutoFilter field:=1, Criteria1:="=*U*"
This does not run properly at all ("AutoFilter method of Range class failed" error)

I am also pretty sure that sequence of autofilter operations will still not accomplish the logic I need. Any suggestions / help would be greatly appreciated.