{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Specific column","SC_ActiveWS","Sale","List","Table","Asterisk"],"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":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Dataset for VBA Delete Columns Based On Header"]
[]
[null,"Order Date","City","Category","Product","Quantity","Unit Price"]
[null,"2022-02-02","Boston","Crackers","Whole Wheat",30,3.49]
[null,"2022-02-03","Los Angeles","Bars","Carrot",35,1.77]
[null,"2022-02-04","New York","Bars","Bran",57,1.87]
[null,"2022-02-05","New York","Snacks","Potato Chips",25,1.68]
[null,"2022-02-06","San Diego","Cookies","Chocolate Chip",24,1.87]
[null,"2022-02-07","Boston","Bars","Bran",83,1.87]
[null,"2022-02-08","Boston","Cookies","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Los Angeles","Bars","Carrot",137,1.77]
[null,"2022-02-10","New York","Cookies","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","New York","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","San Diego","Bars","Carrot",20,1.77]
[null,"2022-02-13","Boston","Cookies","Arrowroot",139,2.1799999999999997]

{"sheet":"Specific column","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"VBA Delete Specific Column from a Range"]
[]
[null,"Order Date","Category","Product","Quantity","Unit Price"]
[null,"2022-02-02","Crackers","Whole Wheat",30,3.49]
[null,"2022-02-03","Bars","Carrot",35,1.77]
[null,"2022-02-04","Bars","Bran",57,1.87]
[null,"2022-02-05","Snacks","Potato Chips",25,1.68]
[null,"2022-02-06","Cookies","Chocolate Chip",24,1.87]
[null,"2022-02-07","Bars","Bran",83,1.87]
[null,"2022-02-08","Cookies","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Bars","Carrot",137,1.77]
[null,"2022-02-10","Cookies","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","Bars","Carrot",20,1.77]
[null,"2022-02-13","Cookies","Arrowroot",139,2.1799999999999997]

{"sheet":"SC_ActiveWS","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"VBA Delete Specific Column from Similar Dataset "]
[]
[null,"Order Date","Category","Product","Quantity","Unit Price"]
[null,"2022-02-02","Crackers","Whole Wheat",30,3.49]
[null,"2022-02-03","Bars","Carrot",35,1.77]
[null,"2022-02-04","Bars","Bran",57,1.87]
[null,"2022-02-05","Snacks","Potato Chips",25,1.68]
[null,"2022-02-06","Cookies","Chocolate Chip",24,1.87]
[null,"2022-02-07","Bars","Bran",83,1.87]
[null,"2022-02-08","Cookies","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Bars","Carrot",137,1.77]
[null,"2022-02-10","Cookies","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","Bars","Carrot",20,1.77]
[null,"2022-02-13","Cookies","Arrowroot",139,2.1799999999999997]

{"sheet":"Sale","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"VBA Delete Specific Columns from Specific Worksheet"]
[]
[null,"Order Date","Category","Product","Quantity","Unit Price"]
[null,"2022-02-02","Crackers","Whole Wheat",30,3.49]
[null,"2022-02-03","Bars","Carrot",35,1.77]
[null,"2022-02-04","Bars","Bran",57,1.87]
[null,"2022-02-05","Snacks","Potato Chips",25,1.68]
[null,"2022-02-06","Cookies","Chocolate Chip",24,1.87]
[null,"2022-02-07","Bars","Bran",83,1.87]
[null,"2022-02-08","Cookies","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Bars","Carrot",137,1.77]
[null,"2022-02-10","Cookies","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","Cookies","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","Bars","Carrot",20,1.77]
[null,"2022-02-13","Cookies","Arrowroot",139,2.1799999999999997]

{"sheet":"List","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Delete Multiple Columns from a Assigned List"]
[]
[null,"Order Date","Product","Quantity","Unit Price"]
[null,"2022-02-02","Whole Wheat",30,3.49]
[null,"2022-02-03","Carrot",35,1.77]
[null,"2022-02-04","Bran",57,1.87]
[null,"2022-02-05","Potato Chips",25,1.68]
[null,"2022-02-06","Chocolate Chip",24,1.87]
[null,"2022-02-07","Bran",83,1.87]
[null,"2022-02-08","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Carrot",137,1.77]
[null,"2022-02-10","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","Carrot",20,1.77]
[null,"2022-02-13","Arrowroot",139,2.1799999999999997]

{"sheet":"Table","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"VBA Delete Specific Column from a Table"]
[]
[null,"Order Date","City","Product","Quantity","Unit Price"]
[null,"2022-02-02","Boston","Whole Wheat",30,3.49]
[null,"2022-02-03","Los Angeles","Carrot",35,1.77]
[null,"2022-02-04","New York","Bran",57,1.87]
[null,"2022-02-05","New York","Potato Chips",25,1.68]
[null,"2022-02-06","San Diego","Chocolate Chip",24,1.87]
[null,"2022-02-07","Boston","Bran",83,1.87]
[null,"2022-02-08","Boston","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Los Angeles","Carrot",137,1.77]
[null,"2022-02-10","New York","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","New York","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","San Diego","Carrot",20,1.77]
[null,"2022-02-13","Boston","Arrowroot",139,2.1799999999999997]

{"sheet":"Asterisk","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Delete Columns with Special Character"]
[]
[null,"Order Date","Product","Quantity","Unit Price"]
[null,"2022-02-02","Whole Wheat",30,3.49]
[null,"2022-02-03","Carrot",35,1.77]
[null,"2022-02-04","Bran",57,1.87]
[null,"2022-02-05","Potato Chips",25,1.68]
[null,"2022-02-06","Chocolate Chip",24,1.87]
[null,"2022-02-07","Bran",83,1.87]
[null,"2022-02-08","Oatmeal Raisin",124,2.8400000000000003]
[null,"2022-02-09","Carrot",137,1.77]
[null,"2022-02-10","Arrowroot",146,2.1799999999999997]
[null,"2022-02-11","Chocolate Chip",34,1.8699999999999999]
[null,"2022-02-12","Carrot",20,1.77]
[null,"2022-02-13","Arrowroot",139,2.1799999999999997]