deleting column A from all sheets

[Lavan]

Hello All,

Is there a way to delete column A from all the sheets of a work book? My spread sheet has nearly 60 sheets.

Thanks in Advance.
Lavan

 

[arthurbr]

Select the first sheet
Then select the last sheet's tab keeping the shift key depressed
Select col A and delete as wanted
Don't forget to ungroup sheets when you're done

 

[VoG]

Or using a macro

Sub c()
Dim s As Worksheet
For Each s In Worksheets
    s.Columns(1).Delete
Next s
End Sub

 

[Lavan]

Thanks a million.

Lavan