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.

Increase a range size by X rows and x Columns...
 

Nevermind. Sorry, offset method (duh!). Please disregard post.

"quartz" wrote:

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.

Increase a range size by X rows and x Columns...
 

Hi quartz

You can use resize

Sub test()
MsgBox Range("B10").Resize(6, 3).Address
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl


"quartz" wrote in message ...
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.

Increase a range size by X rows and x Columns...
 

offset - no (double duh!), resize as Ron suggested.

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Nevermind. Sorry, offset method (duh!). Please disregard post.

"quartz" wrote:

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.