Thank You!!! That worked great
--
BP


"Barb Reinhardt" wrote:

ThisWorkbook.Worksheets("Sheet1").Columns("AA:AY") .Delete
ThisWorkbook.Worksheets("Sheet2").Columns("Z:BD"). Delete
--
HTH,
Barb Reinhardt



"BP" wrote:

I have a workbook with multiple worksheets. I want to delete certain columns
from each worksheet and then save as a new workbook.

Ex:
Worksheet 1: delete columns aa:ay
Worksheet 2: delete columns Z:BD