I have a file where i want to filter the worksheet. I want to eventually KEEP all the numbers in a specific column. However, my approach is to show/filter such that ALL non-numeric entries are shown. Then delete all these rows.
My question is how to use the Autofilter in VBA to show all non-numeric entries in a given column.
Any ideas?
Last edited by welchs101; 08-11-2012 at 09:12 AM.
did some searching and found this soln at this site
Criteria1 ("=*") is a text filter for "one or more of any characters" - so it filters non-zero length text entries. Numeric entries are excluded.
Please Login or Register to view this content.
Criteria2 ("=") is a blanks filter so it returns zero-length entries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks