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

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

Hi,

Sub Delete_B()
For x = 1 To Worksheets.Count
Sheets(x).Columns("B:B").Delete
Next
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"andrei" wrote:


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

.

If this is a one time deal, you can select all of the worksheets (click on
the first worksheet tab, hold down the shift key, then click on the last
worksheet tab) , then select column B. In the menu bar click EDIT/DELETE.

HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"andrei" wrote:


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

.