Remove many hidden excel columns with VBA (macro)
Complete Instructions
Step 1: Open VBA Editor
- Press
Alt + F11(opens VBA editor)
Step 2: Insert Module
- In the VBA editor, click Insert → Module
- A blank code window will appear
Step 3: Paste the Macro
- Copy and paste this code into the module:
Sub
DeleteBetweenCAndQY()
Columns("D:QX").Delete
End Sub