This code is fine if the autofilter selections is filtering data but breaks when the autofilter is already on show all. Problem is I need to ensure that the autofilter is 'reset' to show all before doing the delete.
Please Login or Register to view this content.
Good morning Aussie_Striker
Couple of ways to do this. Determine if the autofilter is active and only run the code if it is. Or easier, stick in an error trap to force your code to continue if it comes across an error :
The first On Error statement sets up the error trap, the second resets it so it won't affect other parts of your code.Please Login or Register to view this content.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
It's actually 9:15pm here...lol, that works well. I haven't used error traps before but sure I will have to in future with the complex things I am trying. Thanks for that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks