MrExcel Publishing
Your One Stop for Excel Tips & Solutions

deleting multiple columns

Posted by anup on December 11, 2001 3:26 AM

I have a sheet with 48 columns. I need to delete the ones containing the letter A. Is there any VB code for this? Is there any alternative to highlighting each cell and then group deleting?

Posted by Mark W. on December 11, 2001 8:01 AM

Use an AutoFilter to diplay the rows for deletion,
select the displayed rows and delete.