Need macro that deletes B columns in all sheets
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 |
Need macro that deletes B columns in all sheets
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 |
Need macro that deletes B columns in all sheets
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 . |
Need macro that deletes B columns in all sheets
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 . |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com