| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 with no increase in rows and columns | Excel Discussion (Misc queries) | |||
| Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
| Size of Workbook(columns/rows/data) | Excel Discussion (Misc queries) | |||
| Increase worksheet size to more than 65,536 rows | Excel Discussion (Misc queries) | |||
| Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
