Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert a blank column between each column in a data file
I have a file with 60 columns, I need to insert a blank column between each
of these 60 columns, is there a macro or command I could use? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert a blank column between each column in a data file
hi
manual = select every other column and hit ctrl++ or you can paste this in a standard module Sub addcol() Dim c As Range Dim cc As Range Set c = Cells(1, 2) For i = 1 To 60 Set cc = c.Offset(0, 1) c.EntireColumn.Insert Set c = cc Next i End Sub regards FSt1 "Holly" wrote: I have a file with 60 columns, I need to insert a blank column between each of these 60 columns, is there a macro or command I could use? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert blank column every other column | Excel Discussion (Misc queries) | |||
Insert A blank Row Everytime the date changes in column B | Excel Discussion (Misc queries) | |||
insert is deleting column data | Excel Discussion (Misc queries) | |||
Find first non-blank or non-zero in a column of data | Excel Discussion (Misc queries) | |||
insert a blank row after data changes in a column | Excel Discussion (Misc queries) |