| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reference variable rectangular range?
I have the following variables:
Const cellName As String = "B2" Const nRow As Long = 5 Const nCol As Long = 10 I want to reference the rectangular range starting from cellName through row cellName+nRow and column cellName+nCol; that is, B2:K7 for the values above. I've come up with the following: Range(cellName, Range(cellName).Cells(nRow, nCol)) Seems tedious. Is that the best I can do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference variable range? | Excel Discussion (Misc queries) | |||
| Making a vertical list from a rectangular range, with no empty lines | Excel Worksheet Functions | |||
| Where is the link? (non-rectangular reference) | Excel Discussion (Misc queries) | |||
| Variable range reference | Excel Discussion (Misc queries) | |||
| Variable Range Reference | Excel Programming | |||
![Joe User[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
