Hello,
I have a macro that auto filters my criteria in Column I. Once that is filtered, I want to delete all of the hidden rows that are not included in on the filter. I do not want to create a loop because it is a large data set and will take too long to loop through each line. Is there anyway to make this faster to auto delete all rows that are not showing after I apply the filter?
I have a macro that auto filters my criteria in Column I. Once that is filtered, I want to delete all of the hidden rows that are not included in on the filter. I do not want to create a loop because it is a large data set and will take too long to loop through each line. Is there anyway to make this faster to auto delete all rows that are not showing after I apply the filter?