How to loop in VBA from autofilters using value "differing from"

0

Good afternoon, doing an automation in VBA in which I need to loop through filters on different lines (sequential values from 1 to 95) but my selection will be with the filter criteria "other than".

Copy the excel tab to a new worksheet, select the value other than 1 and save it with the cell name B2, after that, I automatically close the worksheet, copy the same previous tab and this time filter the values other than 2 , I do the same process sequentially until I complete the number of repetitions.

I can not evolve in the autofilter selection loop, could anyone help me?

    
asked by anonymous 08.05.2018 / 22:45

0 answers