I get a 1004 error on the advanced filtering but if I use the same code as a separate macro in the new file it works fine
Any ideas?
Please Login or Register to view this content.
I get a 1004 error on the advanced filtering but if I use the same code as a separate macro in the new file it works fine
Any ideas?
Please Login or Register to view this content.
Try qualifying the two other occurrences of .Range in the AdvancedFilter line with their WorkSheet parents
If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks