I have a situation where I set the autofilter for columns A:J and then delete columns I:J. If I removed the autofilter and then turn it on again, the auto filter seems to remember that it was originally covering columns A:J. I want to to only recognize columns A:H because I deleted columns I:J.
Why is this happening and how to prevent?