Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting columns on multiple sheets
Hi,
I have a macro that attempts to delete column A on all sheets in the workbook. What it currently does s delete all columns on the first sheet (activesheet) only. For Each ws In ActiveWorkbook.Worksheets Columns("A:A").Select Selection.Delete Shift:=xlToLeft Next Can anyone help to modify the code?? -- K Hogwood-Thompson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting data but not formulae in multiple sheets | Excel Programming | |||
Deleting Duplicate Records across multiple sheets | Excel Worksheet Functions | |||
deleting columns on multiple sheets | Excel Discussion (Misc queries) | |||
Deleting multiple sheets | Excel Programming | |||
Deleting multiple Chart Tabs/sheets | Excel Programming |