G
Guest
I have a worksheet that has an auto filter.
Every now and again... it "stops" working. AS IF there was an empty row
amidst the data. But there is not (I promise.)
When I go into the advanced filter .. I can see that the "range" is limited
down to only.. e.g., row 1061. I can change the range to either row 6000...
or to select all of the columns (rather than state a range) and then put back
the autofilter and it works.
but it will happen again in a bit.
Has anyone ever had this.. bug - I mean feature?
Every now and again... it "stops" working. AS IF there was an empty row
amidst the data. But there is not (I promise.)
When I go into the advanced filter .. I can see that the "range" is limited
down to only.. e.g., row 1061. I can change the range to either row 6000...
or to select all of the columns (rather than state a range) and then put back
the autofilter and it works.
but it will happen again in a bit.
Has anyone ever had this.. bug - I mean feature?