Ask a questionPoojapriya5PostsFriday 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!!!!!