Inserting user input into Macro inserting new columns

[Khalabeeb]

Hi all,

I am writing a macro that inserts new columns according to user input.

However I come up with an error message when using the user input in the code:

(Code)

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

(/Code)

I would like to ask how to properly write the input? (in this case "colLetter")

Thanks,
Nicolas

 

[Fluff]

Try

Columns(colLetter).Insert shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

 

[Khalabeeb]

Thanks!

 

[Fluff]

You're welcome