Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a single cell range named StartRange.
I would like to construct a multi-cell range named TestRange. The first cell of TestRange would be StartRange and the last cell of TestRange would be StartRange.Row + RowInteger, StartRange.Column + ColumnInteger Dim StartRange As Range Dim TestRange As Range Dim RowInteger As Integer Dim ColumnInteger As Integer Set StartRange ActiveCell RowInteger = 4 ColumnInteger = 5 'Doesn't work Set TestRange = Range(StartRange, Range(StartRange).Item(RowInteger,ColumnInteger)) Please help Thanks Jeff Higgins |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Construct staff pay timesheet | Excel Discussion (Misc queries) | |||
I'm Trying to Construct a Smart Worksheet | Excel Worksheet Functions | |||
if else construct | Excel Worksheet Functions | |||
Construct a range in VB | Excel Discussion (Misc queries) | |||
How to construct for best speed? | Excel Programming |