MrExcel Publishing
Your One Stop for Excel Tips & Solutions

delete columns


Posted by amroo on May 09, 2001 1:57 AM

Bonjour,
How to delete all columns begining at the column H (or specified nammed column), on one sheet and on different sheets(2 or more).
A+mroo


Posted by Dave Hawley on May 09, 2001 7:59 AM


Hi Amroo

This should work:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Columns("H:H").Delete
Sheets("Sheet3").Select


The:"Sheets("Sheet3").Select"
will ungroup them

Dave


OzGrid Business Applications