Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Resize the range [Solved/Closed]

Report
Posts
6
Registration date
Friday October 16, 2015
Status
Member
Last seen
August 8, 2017
 -
 Poojapriya -
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!!!!!

2 replies

Answer 1 / 2

Thanks rizvisa1!. your answer solved my problem.

Pooja
6
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Answer 2 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
try this

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

Thanks rizvisa1!. I'll try and let you know
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!