I need to delete rows where values in column B are not equal to an array. Ideally I'd have used autofilter with an <>array but this only works with 2 criteria. I can't use =array with the results I want to delete as occasionally new entries are added. In the end I went for the loop below but due to the multiple queries it takes longer than desired.
Any suggestions to optimise this code or alternative suggestions to achieve the desired result?
Cheers
![]()
Please Login or Register to view this content.
Bookmarks