| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify array function length
I have an array function, let's say from B1 to B100.
I want to modify it to be from B1 to B50. How can I do this without deleting the array and entering the new one? (I need this because I have array functions in a worksheet and I want to copy the functions to other similar worksheets where the length of the array should be different). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build an array constant with DATE function | Excel Worksheet Functions | |||
| Array Function | Excel Worksheet Functions | |||
| MEDIAN() as array function? | Excel Worksheet Functions | |||
| Performing a function on a column of variable length | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
