| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easier way to insert columns
Hi,
I need to insert 40-50 columns and label the headers, at the moment I am using the following code in a macro: Columns("A:A").Select Selection.Insert Shift:=xlToRight Range("A1").Select ActiveCell.FormulaR1C1 = "Status" Columns("C:C").Select Selection.Insert Shift:=xlToRight Range("C1").Select ActiveCell.FormulaR1C1 = "Details" etc Is there an easier way to write this? Thanks! Excel 2002 |
| 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) | |||
| Excel should allow you to create borders around columns easier | Excel Discussion (Misc queries) | |||
| insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
Threaded Mode
