One way:

Columns(sColumn).Offset(0, 1).Resize(, 2).Insert Shift:=xlToRight


In article ,
Les wrote:

Hi all,

sColumn = A

i have this code - Columns(sColumn).Offset(0, 1).Insert Shift:=xlToRight

It works ok but i want it to resize to 2 columns so that it inserts 2 new
columns at B so that B & C are blank rows.

Any help much appreciated.