Resize the range

Solved/Closed
Poojapriya
Posts
6
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 replies

Thanks rizvisa1!. your answer solved my problem.

Pooja
6
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 15, 2015 at 03:29 PM
try this

Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
2
Thanks rizvisa1!. I'll try and let you know
0