Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert blank column every other column
hi,
I have many columns with data A:ACW and I would like to insert a empty column between every other columns so i could enter data. is there any way i could run a macro to do that? thx. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert blank column every other column
Sub InsertColumns()
Dim c As Long Application.ScreenUpdating = False c = Range("IV1").End(xlToLeft).Column For c = c To 2 Step -1 Cells(1, c).EntireColumn.Insert Next c Application.ScreenUpdating = True End Sub HTH Jim May "saman110 via OfficeKB.com" wrote: hi, I have many columns with data A:ACW and I would like to insert a empty column between every other columns so i could enter data. is there any way i could run a macro to do that? thx. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert blank column every other column
Thank you.
Jim May wrote: Sub InsertColumns() Dim c As Long Application.ScreenUpdating = False c = Range("IV1").End(xlToLeft).Column For c = c To 2 Step -1 Cells(1, c).EntireColumn.Insert Next c Application.ScreenUpdating = True End Sub HTH Jim May hi, [quoted text clipped - 3 lines] thx. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM values in this column F only if cell is blank in column Q...HE | Excel Discussion (Misc queries) | |||
Insert A blank Row Everytime the date changes in column B | Excel Discussion (Misc queries) | |||
How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
Warning message if one column contains any text and another column is blank | Excel Worksheet Functions | |||
insert a blank row after data changes in a column | Excel Discussion (Misc queries) |