How to use code to Remove Columns
Requirement:
On the "Current" sheet, the user has a Gantt Chart that I would like to delete columns (dates) as they become the past via using a macro. The problem is that the formulas will become broken and give me the #REF. The user will only delete the dates (shown in rows 24:25) when there is no longer an applicable project (depicted by the green bar in the table).
Solution:
Solution provided by Carim: https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1210161-script-to-remove-columns
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use VBA code to add columns in excel |
| How to use VBA to SUM result in last row in columns A:A |
| How to hide columns in sheet 2 based on data change in sheet 1 |
| How to use code to for stacking repeating grouped columns |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
