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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 226 - Remove filtered data but keep filters

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