Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!swrinde!cs.utexas.edu!uunet!stanford.edu!msi.umn.edu!cs.umn.edu!mmm.serc.3m.com!pejacoby
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Newsgroups: comp.sys.mac.misc
Subject: Excel 3.0 - extend an array?
Summary: Is there a way to extend an array by simply adding rows?
Keywords: Excel array extended array-formula
Message-ID: <1991Apr24.211106.11471@mmm.serc.3m.com>
Date: 24 Apr 91 21:11:06 GMT
Reply-To: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Distribution: comp.sys.mac.misc comp.sys.ibm.pc
Organization: 3M - St. Paul, MN  55144-1000 US
Lines: 29

I have a user running Excel 3.0. He has a variety of array formulas in
one of his sheets, and would like to be able to add rows and columns to
the array without having to redefine/retype the array formulae.  He says
he spoke to MS and they couldn't give him any ideas beyond redefining
the array after adding data.
  Has anyone come up with a good way to do this?  Insert... doesn't like
to do anything because of the array.  I haven't started to think about a
macro, but that's a possibility also.  Anyone bumped their head on this?

  On a related note, this same user would love it if Excel had some way
of defining a formula that could find the end of a data-range by ITSELF.
Kind of like incorporating the SELECT.END() macro command on a worksheet
formula.  The situation is such that a data range varies in length
for each run of an experiment, and there are many formulas which
reference the whole area. He can't just address a 'largest fit' area
because some of the calculations figure in blank cells (hence, a short
set of data in this 'largest fit' area would not give proper results).
A macro has been constructed to adjust formulas, but it'd be quite cool
:-) if this was something the worksheet could do itself.
  Wish list item?

  Please post to e-mail; I'll summarize if returns warrant.  Thanks
  much!
             Paul
-- 
.--------------------------------------------------------------------.
| Paul Jacoby, 3M Company        |  Parachuting?  Why jump out of a  |
| ** pejacoby@3m.com **          |  perfectly good airplane?         |
`--------------------------------------------------------------------'