Filter Question VBA

[MattH1]

I am running a code that filters a large set of data and puts that data into a new file and manipulates it.
I would like to add a few lines to this code that store the filters that do NOT give any data.

For example:

'Filters column V to only one criteria
        ActiveSheet.Range("$A1:$Y" & RowCount).AutoFilter Field:=22, Criteria1:= _
        "A"
'If filter yields no results, go to next filter
If Range("$A1:A" & RowCount).SpecialCells(xlCellTypeVisible).Count = 1 Then
    GoTo Filter2
End If

In this case, Filter2 is the next filter (Which would filter for the Criteria B in the same column).
How do I institute a line of code that would, at the end of the entire process, tell me which items yielded no filtered results? It would me a MsgBox saying
"The following items returned no filter results: A, C, G"
OR
"The following items returned no filter results:
A
C
G"

I would much prefer the second one since the filters aren't A,B,C, etc. but rather large strings of text.

Thanks!

 

[MattH1]

Hoping someone can help me here!!

 

[Norie]

Can we see the rest of the code?

 

[MattH1]

Can we see the rest of the code?

It's nearly a thousand lines of code, it is just putting it into a new document and delimiting and then removing/adding columns and rows and such. And then it goes back to the original worksheet and unfilters the data and then refilters the data (aka starts over).
It's a repetition of this 15 times. I know the code I need has to be within that If statement to move to the next filter is no results show, I just don't know how to make that code.

 

[MattH1]

Tried a few different things to no avail. Can't figure out how to store the ones unfiltered but not store the filtered ones (in terms of putting it out in a message box without all the spacing).

 

[MattH1]

Any help is truly appreciated ....

 

[Norie]

Is the code basically doing the same thing over and over again but with different parameters/criteria?

Are you repeating a lot of code?