Help with Resize
 

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.

--
Les

Help with Resize
 

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.

Help with Resize
 

Thanks very much...
--
Les


"JE McGimpsey" wrote:

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.