{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset","ByReference","ByList","ByRange","ByConcatenating","ConcatenatingAllCol","SearchValue","SearchValueAndColor","ColorOddRows","ColorEvenRows","ForLoopUntilBlank","DoUntilLoopUntilBlank","LoopUntilMultipleBlank","ConcatenatingAllColUntilBlank"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ByReference","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table by Cell Reference with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ByList","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table by List Object with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ByRange","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table by Range Object with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ByConcatenating","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table by Concatenating Columns"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ConcatenatingAllCol","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table by Concatenating All Columns"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"SearchValue","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table for Specific Value with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"SearchValueAndColor","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table for Specific Value and Color It"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ColorOddRows","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table and Color Odd Rows with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,45]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ColorEvenRows","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table and Color Even Rows with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[null,"Seth",104,45]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ForLoopUntilBlank","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"For Loop through Rows of Table Until Blank with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"DoUntilLoopUntilBlank","index":11,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do Until Loop through Rows of Table Until Blank with VBA"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"LoopUntilMultipleBlank","index":12,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows of Table Until Multiple Blank Cells"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]

{"sheet":"ConcatenatingAllColUntilBlank","index":13,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Loop through Rows by Concatenating Columns Until Blank"]
[]
[null,"Student Name","Student ID","Exam Marks"]
[null,"John",101,89]
[null,"Roman",102,56]
[null,"Dean",103,23]
[]
[null,"Finn",105,84]
[null,"Edge",106,67]
[null,"Brock",107,32]
[null,"Rey",108,35]
[null,"Becky",109,78]
[null,"Nikki",110,65]