{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VBA to insert columns","Sample data"],"not_rendered":{"charts":0,"images":4,"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":"VBA to insert columns","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,2],[7,2,7,3]]}
[]
[]
[]
[null,"VBA to Insert Every Other Column in Excel"]
[]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-07-11"]
[null,"Tutorial URL","How to insert columns in Excel"]
[]
[null,"The workbook contains the following macro:"]
[null,"InsertEveryOtherColumn - inserts a blank column between every other column in the selected range."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook in which you want to insert columns."]
[null,"3. In your workbook, select the range where you want to add new columns."]
[null,"4. Press Alt + F8, select the InsertEveryOtherColumn macro, and click Run."]

{"sheet":"Sample data","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Project","Start date","Due date","Duration (days)"]
["Bigfoot","2023-07-29T13:45:43","2023-10-04T16:16:23",{"$f":"INT(C2-B2)","v":67},null,"How to use the macro to insert every other column:"]
["Cascade","2023-06-06T21:41:09","2023-10-02T21:16:08",{"$f":"INT(C3-B3)","v":117},null," "]
["CrimsonWave","2023-07-11T00:18:12","2023-09-29T07:34:50",{"$f":"INT(C4-B4)","v":80},null,"1. Select the range A:D."]
["EquinoxX","2023-07-24T00:15:22","2023-10-26T11:20:56",{"$f":"INT(C5-B5)","v":94},null,"2. Press Alt + F8 to open the macro dialog box."]
["Hornets","2023-06-28T08:09:34","2023-10-04T09:43:01",{"$f":"INT(C6-B6)","v":98},null,"3. Choose the InsertEveryOtherColumn macro."]
["Mercury","2023-05-18T20:05:18","2023-10-28T23:44:13",{"$f":"INT(C7-B7)","v":163},null,"4. Click Run to execute the code."]
["Moonstruck","2023-05-07T04:13:07","2023-08-23T22:35:39",{"$f":"INT(C8-B8)","v":108}]
["NovaQuest","2023-06-30T07:48:53","2023-08-11T03:10:39",{"$f":"INT(C9-B9)","v":41}]
["Peak-Blast","2023-05-14T20:12:57","2023-08-12T18:13:49",{"$f":"INT(C10-B10)","v":89}]
["PhoenixRise","2023-06-17T17:05:34","2023-09-02T11:22:31",{"$f":"INT(C11-B11)","v":76}]
["Skill-Up","2023-05-18T00:58:05","2023-09-30T05:36:45",{"$f":"INT(C12-B12)","v":135}]
["SolarFlare","2023-03-28T05:16:48","2023-10-02T04:15:03",{"$f":"INT(C13-B13)","v":187}]
["Sputnik","2023-05-30T20:20:17","2023-09-27T10:19:26",{"$f":"INT(C14-B14)","v":119}]
["ThunderTide","2023-07-29T10:45:46","2023-09-28T00:02:56",{"$f":"INT(C15-B15)","v":60}]
["Tip-Row","2023-06-03T04:15:56","2023-09-30T22:58:16",{"$f":"INT(C16-B16)","v":119}]
["VelocityVortex","2023-04-23T23:43:02","2023-10-23T00:22:04",{"$f":"INT(C17-B17)","v":182}]
["Whistler","2023-06-25T14:49:43","2023-10-14T22:00:31",{"$f":"INT(C18-B18)","v":111}]
["Wildfire","2023-05-23T06:00:02","2023-10-29T02:00:25",{"$f":"INT(C19-B19)","v":158}]
["Yaeger","2023-04-26T21:29:40","2023-10-17T15:46:45",{"$f":"INT(C20-B20)","v":173}]
["ZenithZone","2023-05-07T10:11:51","2023-09-25T02:52:28",{"$f":"INT(C21-B21)","v":140}]