View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default 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.