OzGrid

How to use code to Remove Columns

< Back to Search results

 Category: [Excel]  Demo Available 

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



stars (0 Reviews)