Resize the range

Solved/Closed

Poojapriya Posts 6 Registration date Friday October 16, 2015 Status Member Last seen August 8, 2017 - Dec 14, 2015 at 12:24 AM
Poojapriya - Dec 16, 2015 at 12:41 AM

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

Resize the range
Apple airtag range - Guide
Gparted cli resize partition - Guide
Resize web page to fit screen html - Guide
Wimax frequency range - Guide
If function with date range - Guide

2 responses

Answer 1 / 2

Poojapriya
Dec 16, 2015 at 12:41 AM

Thanks rizvisa1!. your answer solved my problem.

Pooja

Answer 2 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 15, 2015 at 03:29 PM

try this

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

Poojapriya
Dec 15, 2015 at 11:26 PM

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

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Copy range data in a column to new column.

Excel if range of cell contain a text put a cell value in

range of numbers

Similar discussions

Subscribe To Our Newsletter!