Previous Topic Next Topic

Resize the range

Solved/Closed
Poojapriya Posts 3 Registration date Friday October 16, 2015 Status Member Last seen August 8, 2017 - Dec 14, 2015 at 12:24 AM
 Poojapriya - Dec 16, 2015 at 12:41 AM
Greetings,
I would like to resize the range without keeping the starting position. I've attached the image


In the above example, while using Rngname.currentregion.address property results in referring "A5:D7".Using resize property(Rngname.currentregion.address.resize(rowcount,rngname.currentregion.columns.count-1) result in referring "A5:C7".But,I would like to have address value as "B5:D7".

Thanks in advance for your help!!!!!

2 responses

Answer 1 / 2
Poojapriya
Dec 16, 2015 at 12:41 AM
Thanks rizvisa1!. your answer solved my problem.

Pooja
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 15, 2015 at 03:29 PM
try this

Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
Poojapriya
Dec 15, 2015 at 11:26 PM
Thanks rizvisa1!. I'll try and let you know

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
range of numbers
whatsit -
Mazzaropi -

3 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses