Link to home
Start Free TrialLog in
Avatar of Tosagua
Tosagua

asked on

Excel - Delete Every Nth (3rd) column.

I have searched EE without finding any ideas on how to do this.

We need to delete evert Third column, starting with column E.

Any assistance or insight would be greatly appreciated.

Tosagua
ASKER CERTIFIED SOLUTION
Avatar of Shaun Kline
Shaun Kline
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So you would need a macro that:
You cou
You can make ActiveCell column E byt offersetting (0, 5) if 5 if column E.
then offset (0, 3) and delete.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tosagua
Tosagua

ASKER

I am sorry about this, but I accepted your solution and awarded the points last week. Unfortunately, I am stuck using Internet Explorer 8, which doesn’t work well on Experts Exchange, while IE 11 continually crashes.

Shaun's solution works well on large spreadsheet with more than 200 columns. But ProfessorsJimJam's solution is ideal for smaller spreadsheets. Both solutions are going into our library.

Thank you for the assistance.

Tosagua