View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
samlyon samlyon is offline
external usenet poster
 
Posts: 2
Default Making a change in all worksheets

I am trying to delete a column in all worksheets. The code i'm using only
deletes the column in the first worksheet, but not the rest of them.

Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
Columns("D:D").Select
Selection.Delete Shift:=xlToLeft
Next sht

Any help would be greatly appreciated.