Help with Resize

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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.
 
One way:

Columns(sColumn).Offset(0, 1).Resize(, 2).Insert Shift:=xlToRight
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resize a row but copy but skip columns I don't want to copy 6
Find ActiveCell.column 4
Clean this select case code up a bit. 2
Insert columns and values programmatically with IF statement 9
Insert Border 2
Help needed with Very slow code Please 11
Copy columns and paste with blank column between 5
OFFSET LOOKUP function in VBA? 9

Back
Top