Columns

Home Search Site Map

Up
Cells...
Chart...
Columns
Comment
Diagram...
Function...
Hyperlink...
Name
Object...
Page Break
Picture
Rows
Symbol...
Worksheet

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Columns  

Inserts a column(s) from the current selected cell(s) or column(s). Columns can only be moved right , so careful pre-selection is very important.

Sub InsertColumns()
'Insert three columns at Column C
Columns("C:E").EntireColumn.Insert
End Subub

Copyright Nick Hodge 2008. All Rights Reserved.