Have you considered using the AuotoFilter to filter out what you don't want?
I actually considered it and even the manual hide of rows. I was planning to take it a step further if it could be done using macro.
Posts by JokerJester
-
-
Hi Guys!
It's my first time here in OzGrid and would want to seek for your help.
What I would want to do is to:
1. Hide the rows that has the value of "FALSE" as a result of an IF and VLOOKUP formula.
2. Select the cells and set the print area.
3. Print as PDF - I am already good with this
Thank you.