Devon,
Yes, the subroutine reminds me how I would rather
use J, if possible, instead of using the macro language. J
and spreadsheets are so similar, but so different. I won't
presume to suggest alternatives for your problem associated
with appending new data.
On Thu, 20 May 2010, Devon McCormick wrote:
One annoyance I find with current spreadsheet notation is formulas, in
general, are not aware of the range of cells over which they operate. So,
if I'm summing a column of numbers and append more numbers to the bottom of
the column (I usually write my summary information at the top of a sheet as
this is more convenient), it's easy to get it wrong if I forget to adjust
the formula or adjust it incorrectly.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm