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
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