• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide Recurrence Setting

C

cyliyu

Member
I have a workbook consists of 50 of sheets.
I want to hide the entire row where the column-Recurrence contain a number of "2".
The "Recurrence" is not always in the same "column", in the example attached, Sheet 1- Column "G" and Sheet 2- Column "I".
I also want the code to be "flexible" to allow me to change and set the criteria to "1", "2" or "3" and so on.
Need help, please.
 

Attachments

  • HideRecurrence.xlsx
    9.8 KB · Views: 3
cyliyu
Something like this ... press the button?
Note: negative numbers will unhide row
 

Attachments

  • HideRecurrence.xlsb
    20.2 KB · Views: 9
Thanks. The code in the file work.
Let me try in my workbook when back to the office tomorrow.
Appreciate your help.
 
You must log in or register to reply here.
Back
Top