Asked • 07/12/19

Deleting Two Columns Simultaneously?

The following code deletes Column J only: If Application.WorksheetFunction.Sum(Range("J:J").SpecialCells(xlCellTypeVisible)) _ = Application.WorksheetFunction.Sum(Range("L:L").SpecialCells( _ xlCellTypeVisible)) Then Columns("J:J").Delete Shift:=xlToLeft 'instead of .Select and Selection. End If However, I would like to delete both columns `J` and `L` at the same time. How can I do this?

1 Expert Answer


Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.