Resize the rangeSolved/Closed

Question

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!!!!!

Poojapriya · Accepted Answer

Thanks rizvisa1!. your answer solved my problem. 

Pooja

rizvisa1 · Answer

try this

Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)

Resize the range

2 replies

Subscribe To Our Newsletter!