I am new to the board but have spent a lot of time "living inside" Excel VBA code. I am trying to find VBA code that lists or "gets" the criteria for each column once autofilter is on.
Is there a VBA function that can do this? Is there a way to "loop" through each criteria and store in an array?
Mike
Is there a VBA function that can do this? Is there a way to "loop" through each criteria and store in an array?
Mike