PDA

View Full Version : Named Ranges in Excel VBA



Dizzley
05-11-2007, 02:55 AM
VBA newbie alert! :)

Excel 2003.

I've coded using cell references and want to tidy up and use named ranges like a good boy. ;)

E.g.

' Insert status column
Columns("I:I").Insert Shift:=xlToRight
Range("I6").Formula = "STATUS"
numcolumns = numcolumns + 1

(Should work on any normal workbook)

How would I replace Columns("I:I").Insert Shift:=xlToRight using a range?

I've been digging around for hours... :banghead:

The macros will be in a "macros.xls" workbook and from there I will open a series of workbooks and apply code like that above (but lots more).

Ta in advance,
Pete

Bob Phillips
05-11-2007, 03:33 AM
Range("myCell").EntireColumn.Insert Shift:=xlToRight