I have a spread shee that is dynamic, it changes every week and the number of records change aswell. I want to autofilter a specific coulmn using multiple criteria. these are run in a single macro, not as a seprate sub. I am very new to VBA coding, so please be specific in explination, Thank you in advance.
My code is:
OR
I then want to Delete all of them, I have read uch about this but I seem to be very unsuccesfull in exacuting it. This is the best I got at this attempt:
I attached a dumbed down sample of the spreadsheet I am working with. I need to delete all rows that have a status of 70, 80, or 90.
Additional FYI- I am using Excel 2007
thanks
Bookmarks