View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] andrewhharmon@gmail.com is offline
external usenet poster
 
Posts: 1
Default Excel Array Formulas

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