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
Poojapriya - Dec 16, 2015 at 12:41 AM
Related:
- Resize the range
- Selection.autofill destination:=range ✓ - Excel Forum
- Excel if range of cells contains specific text ✓ - Excel Forum
- Gparted command line resize partition - Guide
- Html resize table to fit screen - Guide
- If statement with date range - Guide
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Dec 15, 2015 at 03:29 PM
Dec 15, 2015 at 03:29 PM
try this
Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)