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

[Guest]

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: B1015

Please help...thanks in advance.

 

[Guest]

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

 

[Ron de Bruin]

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

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?

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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

rows and columns programatically. How can I obtain the ending range address
without actually making a selection?