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

Q

quartz

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.
 
R

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


quartz said:
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
Click to expand...
ending range address without actually making a selection?
 
T

Tom Ogilvy

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

--
Regards,
Tom Ogilvy

quartz said:
Nevermind. Sorry, offset method (duh!). Please disregard post.
Click to expand...
rows and columns programatically. How can I obtain the ending range address
without actually making a selection?
 
Top