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
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!!!!!
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!!!!!
Related:
- Resize the range
- How to increase the wifi range - Guide
- Gparted cli resize partition - Guide
- Apple airtag range - Guide
- Karbikes electric bike range - Home - Apps & Sites
- Wimax frequency range - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 15, 2015 at 03:29 PM
Dec 15, 2015 at 03:29 PM
try this
Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
