hi,
i am using this code to unfilter data if it is on filter mode,
i need some changes in this code![]()
If Worksheets("SUMALL").FilterMode Then Worksheets("SUMALL").ShowAllData Else End If
i want if i filtered range with some string for example "aam"
i press this code the this one clear the filter mode from range,
now i want i again press this code then this code do filter as it was before
i mean it filter again string "aam"
thank you
Bookmarks