simplistically:
Sub test()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Columns("B").EntireColumn.Delete
Next
End Sub
--
Gary Keramidas
Excel 2003
"andrei" wrote in message
...
Hello ,
I need a macro that delets B column in all sheets in a workbook
THanks !
--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=176295
Microsoft Office Help