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