AUTOFILTER - Clearing

[Logit]

.
Is there a method of AUTOFILTER UNDO for the affected rows only ?

It appears from internet research that any method of clearing an AUTOFILTER involves all 1.4 million rows.

This is a macro I've tried, specifying a range of rows, but it takes the same amount of time as any other macro in making the hidden rows visible again :

Please Login or Register  to view this content.

Any suggestions how to restrict the AUTOFILTER = False to the first 1,000 rows ?

Thanks.

[mehmetcik]

This unhide rows 1000 rows. The question is are they unfiltered.

Please Login or Register  to view this content.

Answer Yes. Sorry. No

[Logit]

.
mehmetcik :


Thank you for your response.

Rows("2:1001").Hidden = False takes same amount of time to clear filter.

[Logit]

.
This is the Autofilter macro :

Please Login or Register  to view this content.

[mehmetcik]

Maybe try all methods to speed up vba:

Please Login or Register  to view this content.

[Logit]

.
mehmetcik :


I certainly appreciate your willingness to look at this. Thank you.

Here is the workbook.


Your last suggestion took the same amount of time. Sorry.

[Logit]

.
mehmetcik :


The workbook has formatting, pasted grid lines down to row 5003. It also has background coloring, Col A, down to the last row
of the worksheet.

I eliminated all of that below row 1003 and the speed has greatly increased.

It is a shame that VBA is unable to perform the same function, as fast, regardless of how many rows are "in play".



I'll consider this issue resolved until a better solution, using as many rows as desired, is presented. Thank you for your
assistance.

Cheers !