AutoFilter Speed Issue

Can anyone help me with an alternative to autofilter.

I have no issues when the Size is say 5000 Rows but when i have more records in my sheet excel just times out and ends with an Error.

Note: I am using the statement below within the for loop

Sheets("MergedDataSheetQ").Range(rplRange.Offset(0, 0), rplRange.Offset(sizeData, noColumns + 2)).AutoFilter Field:=noColumns + 1, Criteria1:=SubSector

Is there any work around so that i only change the criteria inside the loop or something like, so that the i reduce the execution time for this statement?

Hi Rohan

Please take a moment to read the forum rules, especially about cross posting and code tags.

You'll find many skilled and willing helpers here, but you must be prepared to do your bit!

cheers