Insert multiple columns across Workbooks using VBA in Excel
In summary, the example workbooks which the above video showcased on how to compose the macro are located at the following:
https://spreadsheetvault.com/insert-c...
Description:
This presentation will outline an approach to create a macro, which will enable users to insert columns across worksheets, across all open workbooks.
The macro to insert columns across workbooks contains two loops. One to loop through the workbooks. Whilst a second to loop through the worksheets for each individual workbooks.