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
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 
moins plus
Thanks rizvisa1!. your answer solved my problem.

Add comment
moins plus
try this

Poojapriya- Dec 15, 2015 11:26PM
Thanks rizvisa1!. I'll try and let you know
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!