I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering from turning off? Or, alternatively, to get the current setting with a macro command before the view is switched and then applying it again after the view is switched? Thanks!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!