Sort and remove duplicates based on 3 columns

[gauti14]

across like 20 sheets in same work book i need to sort 2 columns in ascending order and then remove duplicates based on 1,2 and 7th columns..i have written something like this..but i am getting Autofilter method of range class failed error..can someone check the code pls:

Please Login or Register  to view this content.

[JLGWhiz]

Since it is not already in AutoFilterMode it is probably expecting some parameters and since there are none, it gives the alert. You don't need the AutoFilter in order to sort. Just use the Sort method by itself.