Thread: Need macro that deletes B columns in all sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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

.

Reply With QuoteReply With Quote