Hi,

This will find 'Stock Code ' in row 1 and insert a column to the left

Range("IV1").End(xlToLeft).Find(What:="stock code", _
MatchCase:=False).EntireColumn.Insert

Mike

"pol" wrote:

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