Report

Resize the range [Solved]

Ask a question Poojapriya 5Posts Friday October 16, 2015Registration date April 4, 2016 Last seen - Latest answer on Dec 16, 2015 12:41AM
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!!!!!
See more 
Helpful
+6
moins plus
Thanks rizvisa1!. your answer solved my problem.

Pooja
Add comment
Helpful
+2
moins plus
try this

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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!