To find the column with its column heading
Cells(1, WorksheetFunction.Match("STOCK CODE", Rows("1:1"),
0)).EntireColumn.Insert
Regards,
Stefi
€˛pol€¯ ezt Ć*rta:
I have an excel sheet with column heading 'STOCK CODE' I want to insert a
column just left side of that column 'STOCK CODE' where it is. please let me
know to write a macros.
With thanks
Pol
|