Switching custom view when filtered

T

tsbarr

I have a very large spreadsheet that I navigate using custom views. I change
views using macros because I have a couple of other commands that I want
executed as well. I also commonly filter the rows of the spreadsheet.
However, when I switch views, the filter is turned off, and I would like it
to remain filtered as is. Is there a way to stop the filtering from being
turned off? Or can I get the filter setting with a VB command and then
reapply it at the end of the macro? Thanks!
 
T

tsbarr

correction - I filter a particular column, not rows, hiding the rows that
don't meet the criteria. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom View Weirdness 0
Auto filter for multiple columns 2
Custom Views + hidden columns does seem to work 0
Custom Views 0
Filling in another sheet with filtered data 3
Excel 2007 compatibility issue - speed between cells 2
Saving Auto-Filtered Data (or deleting the rest) 3
Using the Autofill, with filtered lists 1

Top