Copy and pasting columns in VBA - with formula adapting to new location

[Khalabeeb]

Hi all,

I have the following code to insert a new column:

(Code)

colLetter = InputBox("Please enter replication factor column:", "Factor column")
Columns(colLetter).Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

(/Code)

Let's say: colLetter = "M"
In the new inserted column, I would like to copy/paste the content (values and formulas) from the adjacent column, "L", into the new inserted "M" column. With the formulas adapting to their new location (i.e. same as manually copy/pasting the columns).

Does someone know how to write the syntax for such a command?

Thanks in advance,
Nicolas