| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
| RESIZE PROPERTY: is it possible to resize "up" and "to the left"? | Excel Programming | |||
| I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
| Resize name box | Setting up and Configuration of Excel | |||
| Need some help with Resize. Thanks | Excel Programming | |||
Linear Mode
