| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I do a variable length array based on the value in a cell
I want to create a cell range that will be based on the value of a cell so
that i can change the value of the cell and the range will lengthened or shortened. Say I want to have the range start at cell b1 and go down the column for 10 cells. then I decide to change it to 15 cells and then 40 cells. But I don't want to have to rewrite the formula each time. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a cell value based on specific combinations of cells in an array | Excel Worksheet Functions | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Threaded Mode
