Can an expert provide me with VBA code that will filter then delete the data in that range but only that range.
So the range is A-N. I need to filter Column ‘I’ with Credit and then delete anything that now appears in that filter then unfilter.
There is a pivot table in cells R-S and I do not want to delete this.
I am using below code on other sheets where there is no pivot and this works fine but it deletes entire row.
Thank you in advance