| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range to change size according to number in another cell
Hi, Can anyone help with this.
I need a range to change its size according to a number in anther range/Cell. For example, this is the range thats spans down 4000 rows: ActiveWorkbook.Names("Range_B").RefersToR1C1 = "=Sheet1!R4C6:R4000C7" And if the other Range/Cell = 500, I would want the Rang_B to change to 500 rows I can put something together consisting of lots of IFs, but I just need a short piece of code that can do it more efficiently. Help greatly appreciated Regards John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the font size of excel row number and column heading | Excel Discussion (Misc queries) | |||
| change size of a cell | New Users to Excel | |||
| HOW DO I CHANGE THE FONT SIZE FOR A RANGE NAME? | Excel Discussion (Misc queries) | |||
| Change fmt of a cell if number matches any in a range of cells? | Excel Worksheet Functions | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
Threaded Mode
