| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete coloum in VB
Hi I have an excel table contain 29 sheets. I need to delete the entire
coloum of CA to ET in all sheets. Is there anyone could help me generate the VB code. -- Sincerely Yours Haviv |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete coloum in VB
Hi,
Try this but be careful it will delete that range in every sheet in the workbook. Is that what you want? Sub versive() Dim ws As Worksheet For x = 1 To Worksheets.Count Sheets(x).Range("CA:ET").EntireColumn.Delete Next End Sub Mike "haviv" wrote: Hi I have an excel table contain 29 sheets. I need to delete the entire coloum of CA to ET in all sheets. Is there anyone could help me generate the VB code. -- Sincerely Yours Haviv |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete coloum in VB
Sub delete_cols()
Application.ScreenUpdating = False Dim N As Single For N = 1 To Sheets.Count Sheets(N).Columns("CA:ET").Delete Next N Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Thu, 11 Sep 2008 00:21:01 -0700, haviv wrote: Hi I have an excel table contain 29 sheets. I need to delete the entire coloum of CA to ET in all sheets. Is there anyone could help me generate the VB code. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete coloum in VB
Hi Thank you very much its working.
-- Sincerely Yours Haviv "Mike H" wrote: Hi, Try this but be careful it will delete that range in every sheet in the workbook. Is that what you want? Sub versive() Dim ws As Worksheet For x = 1 To Worksheets.Count Sheets(x).Range("CA:ET").EntireColumn.Delete Next End Sub Mike "haviv" wrote: Hi I have an excel table contain 29 sheets. I need to delete the entire coloum of CA to ET in all sheets. Is there anyone could help me generate the VB code. -- Sincerely Yours Haviv |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on how to raise a price 15% in a coloum | Excel Discussion (Misc queries) | |||
| how to change coloum to row | Excel Worksheet Functions | |||
| Regonise coloum A while adding up coloum B to give a result in C | Excel Discussion (Misc queries) | |||
| Need to import data to a coloum not a row | Excel Discussion (Misc queries) | |||
| Chart Coloum Labels - Very Urgent | Charts and Charting in Excel | |||
Linear Mode
