You are talking about user macros here.
Yes, the macros are meant to mimic just
use actions, like keystroke commands and
menu selections.
But Excel, which uses an OOP approach,
already operates the Object Model, where you
can say Sheet(1).Range("A1:B2").
Although some macros were useful and kept
in Excel 4.0 compatibility. AFIR, since you dont
have to program in the IDE, but can put a macro
expression right in the cell.
----- Original Message ----
From: dly <[EMAIL PROTECTED]>
To: General forum <[email protected]>
Sent: Friday, June 16, 2006 7:21:14 AM
Subject: Re: [Jgeneral] spreadsheets
In general, you can put expressions in cells of spreadsheets which
direct there results to other cell ranges. You can put script-like
code in cells that don't get displayed in the viewing section. The
spreadsheet can actually be much like a workspace in many respects.
In my first Lotus123 application I was using (if I recall) a {left}
{left}{left}... command to move the cursor around the spreadsheet.
(Used APL to read budget data into a worksheet and have Budget
managers update etc--directing them to input fields.) Being dyslexic
I initially used {left}{left}{left}... when I meant {right}{right}
{right}...in those days you couldn't just say move left 20 cells.
Worth looking into? I hope you have other options.
Donna
[EMAIL PROTECTED]
On 10-Jun-06, at 8:40 PM, Randy MacDonald wrote:
> This ability to express array constants seems like a trivial
> extension of
> cell ranges. I don't see how the result of the expression can be an
> array.
> Does Excel display a cell with the formula '({1,2,3})' for example,
> or does
> something like "<<ARRAY>>" show up in the cell?
>
> I've got the Open Office spreadsheet on my box someplace. Is _that_
> worth
> exploring, anyone?
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
