Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a simple formula that returns an array. This array is of
unkown number of rows and columns. Currently I enter the formula into a cell, then drag and select a large numner of cells and use ctrl + shift + enter to have the cells populate the array formula results. The problem is that i don't know how far i have to drag. it is a lot of trial and error. Is there anyway to have a function return an array and populate it to the correct number of cells? Thanks for your help. -Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alternative program to Excel for array formulas | Excel Discussion (Misc queries) | |||
Array formulas not working in Excel 2003. | Excel Worksheet Functions | |||
Formulas assignment from array to range in VSTO Excel doesn't work | Excel Worksheet Functions | |||
excel 2000 - array formulas | Excel Worksheet Functions | |||
Excel array formulas | Excel Discussion (Misc queries) |