Increase a range size by X rows and x Columns...
Suppose I have a single cell starting range of "B10"
Now suppose I need to increase this range size by a specific number of rows and columns programatically. How can I obtain the ending range address without actually making a selection?
For example, start range "B10"
Increase rows: 5 and increase columns: 3
New range: B10:D15
Please help...thanks in advance.
|