Good way to hide rows?

[Jyggalag]

Hi all,

I have an overview like this:

I am looking at four quarters for a year. I have a filter as well.

I want to specifically hide the first three quarters somehow. However, please note that: 1) I cannot use a filter, because I often use a macro that wont work if a filter is on, and 2) I would like to seek an alternative solution rather than simply hiding the rows, so preferably something as similar to a filter as possible

any suggestions ?

 

[Candyman8019]

You could adjust your macro to clear the filter at the start...do what ever the macro does, then reapply the filter before the end of the script.

 

[Jyggalag]

You could adjust your macro to clear the filter at the start...do what ever the macro does, then reapply the filter before the end of the script.

hm that is actually very smart.

wow cant believe i didnt think of this lol

thank you so much!