RWayneH
asked on
Deleting rows of data that are results of Autofilter?
I am looking for a VBA script that is simple and deletes all visible rows in an autofilter. I already have the filters applied, I just need to delete everything (except the headers). I find myself needing this more often.. or better yet, have a visible property that would delete visible if true, or delete all hidden if false.. sort of a tool to use when dealing with autofilters. Hope this makes sense. -R-
ASKER
so you are assuming I only have 65K rows? Does this allow for header row? need to keep that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. -R-
Open in new window