pejacoby@mmm.serc.3m.com (Paul E. Jacoby) (04/25/91)
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? |
`--------------------------------------------------------------------'