Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Columns
Hi,
I have 26 columns of data from (B:AA). Their headers are in row 1. I am trying to get a code that will insert 1 column next to each colum of data and copy the header over into the blank column. Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Columns
Dim i As Long
For i = 27 To 1 Step -1 Columns(i + 1).EntireColumn.Insert Cells(1, i + 1).Value = Cells(1, i).Value Next i -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Scottmk " wrote in message ... Hi, I have 26 columns of data from (B:AA). Their headers are in row 1. I am trying to get a code that will insert 1 column next to each column of data and copy the header over into the blank column. Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Columns
Thanks Bob!! one thing, I don't want a column inserted after A. I want
it to start at B. Thanks --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Columns
Sorry Scott,
just change it to Dim i As Long For i = 27 To 2 Step -1 Columns(i + 1).EntireColumn.Insert Cells(1, i + 1).Value = Cells(1, i).Value Next i -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Scottmk " wrote in message ... Thanks Bob!! one thing, I don't want a column inserted after A. I want it to start at B. Thanks --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Columns
Thanks for all of your help Bob...I really appreciate it.
Scot -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert columns of dates in between exsisting columns of | Excel Discussion (Misc queries) | |||
can no longer insert new columns & unhide hidden columns | Excel Worksheet Functions | |||
unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
Using VBA to insert Columns | Excel Worksheet Functions |