{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Dataset","Single","Contiguous","Non-Contiguous","Texts","Numbers","Zero","Negative","Positive","Odd","Even","Greater Than","Less Than","Cell Text Value","Cell Num Value","Inserted Criteria"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Single","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Single Row with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Contiguous","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Contiguous Rows with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Non-Contiguous","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Non-Contiguous Rows with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Texts","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide All Rows Containing Texts with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Numbers","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide All Rows Containing Numbers with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Zero","index":6,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Containing 0 with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,0,100,30]
[null,"Grade","A","A+","N/A","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Negative","index":7,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Rows Containing Negative Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,-10,100,30]
[null,"Grade","A","A+","N/A","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Positive","index":8,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Rows Containing Positive Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,0,75,66]

{"sheet":"Odd","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Containing Odd Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Even","index":10,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Containing Even Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Greater Than","index":11,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Greater Than Condition with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Less Than","index":12,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Less Than Condition with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Cell Text Value","index":13,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Based on Cell Text Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Cell Num Value","index":14,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Hide Row Based on Cell Numeric Value with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]

{"sheet":"Inserted Criteria","index":15,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[11,2,11,3]]}
[]
[null,"Hide Row Based on Inserted Criteria in Worksheet with VBA"]
[]
[null,"First Name","John","Roman","Finn","Seth","Dean"]
[null,"Last Name","Cena","Reigns","Balor","Rollins","Ambrose"]
[null,"Department","Physics","Chemistry","Biology","Mathematics","Literature"]
[null,"Marks",65,87,55,100,30]
[null,"Grade","A","A+","B","A+","F"]
[null,"DOB","1991-04-13","1992-02-21","1992-12-31","1993-11-10","1994-09-20"]
[null,"Retake Marks",69,88,82,75,66]
[]
[null,null,"Criteria to Hide Row",null,"Biology"]