Here's the code..
It seems i've tried every variation of filter clearing code and nothing seems to work..
I'm starting to pull my hair out over this..
Here's what I want to do in laymans terms:
1) Open the "Dummy sheet."
2) Check if there are any filters on, and if so, clear them
3) Copy the entire visible data set
4) Close the "Dummy Sheet"
5) Copy the data to "Copy of Master Sheet"
... and go from there..
The issue is getting the Dummy Sheet to clear any filters that are on before copying the info to another workbook.
I know there's alot of useless code in there at the moment but I've left it to remind myself of what i've tried and what hasn't worked..Please Login or Register to view this content.
Any help?
Thanks,
Bookmarks