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

By:

Brian L. answered • 11/17/20

Tutor
5 (7)

University of Michigan Engineering Graduate for Math Tutoring

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

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

#### OR

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