Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Could someone give me a code that will delete every other colum between cells B:BA starting with cell B. There are 52 cells betweee B:BA including them. Don't know if that helps or not. Here is a cod I tried that basically took a long time before deleting all columns: Dim i As Long For i = 52 To 2 Step -1 Columns(i + 1).EntireColumn.Delete Next i Since this is a relatively short code, could someone break it down fo me also? I am really trying to learn this stuff, I have bought 3 book but I just never feel like reading them after work. Thanks, Scott -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete columns if 0 | New Users to Excel | |||
Delete Columns | New Users to Excel | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Can't delete columns | Excel Discussion (Misc queries) | |||
Delete columns | Excel Programming |