Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi again
I am trying to insert a column into an excel sheet. Using VBA it read like this: 'shift cells to right Range("E:E,H:H,K:K,N:N,Q:Q,T:T,W:W,Z:Z,AC:AC,AF:AF ,AI:AI").Select Selection.Insert Shift:=xlToRight I am trying to do this in VB this way. I am not sure of the syntax For i = 2 To 31 Step 4 Selection.Insert Shift:=xlToRight Next Any one with the equivalent in VB would be appreciated -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting blank rows plus using Sum | New Users to Excel | |||
Totalling columns & inserting blank row afterwards | Excel Discussion (Misc queries) | |||
inserting a blank row | Excel Discussion (Misc queries) | |||
Can parital cells be underlined w/o inserting blank columns? | Excel Discussion (Misc queries) | |||
Formula for inserting blank row | Excel Worksheet Functions |