By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Remove filtered data but keep filters

On error resume next
if activesheet.AutoFilterMode then
Activesheet.ShowAllData
end if