Switching custom view when filtered

  • Thread starter Thread starter tsbarr
  • Start date Start date
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!
 
correction - I filter a particular column, not rows, hiding the rows that
don't meet the criteria. :-)
 
Back
Top