Resize the range [Solved/Closed]

Report
Posts
6
Registration date
Friday October 16, 2015
Status
Member
Last seen
August 8, 2017
-
 Poojapriya -
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
try this

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!