Rajagopalan TA wrote:
Absurd... Even I get the same Error, When see the actual code by editing the macro I
could see that the macro moves to Actual cursor to A2 and A1, (Which I understand is how
it interpreted the Up-Arrow) and then writes the formula "=A2+A1" in Cell A1...
Which I why the error message comes in A1.
I'm not sure what to say more on this... I feel the Quality of Macro Recorder
is very poor... It has somehow distinguish that user is editing the formula of
a cell and not moving the Actual cursor.
- Raja
-----Original Message-----
From: Jean-Michel Courat [mailto:jeanmichel.cou...@gmail.com]
Sent: Thursday, August 06, 2009 2:47 PM
To: users@openoffice.org
Subject: problem writing a simple macro
In a spreadsheet,
A1 = 1
A2 = 2
Starting in A3, when doing with keystrokes
+
arrow up (going to A2)
+
arrow up (going to A1)
Enter
I obtain 3 in A3
When recording the macro the same way, I also obtain 3 in A3; great !!
But when executing the macro, I obtain a message error 523 in A1.
What am I doing wrong ?
Thanks
JMC
Disclaimer:-
This e-mail transmission may contain proprietary,confidential or legally
privileged information (including encrypted Individually Identifiable
Health Information) that is intended only for the individual(s) or
entity(ies) named in the email address. If you are not the intended
recipient please notify the sender and destroy this email and any
attachments immediately. Any unauthorized use or distribution of this
message in whole or in part is strictly prohibited.
Eco friendly practice - THINK BEFORE YOU PRINT: before printing this
email think whether it is really necessary.
GreenTree (Reduce. Reuse. Recycle.)
I played around with the macro recorder, and I obtained the same error
when using the arrow keys. However, when I just typed in the commands
in the following manner, it worked:
1. Select record macro.
2. Type =
3. Type A1
4. Type +
5. Type A2
6. Type Enter
7. Select Stop Recording
8. Save the macro.
Now, select a cell and run the macro. You'll get 3 in the selected cell.
For some reason the macro recorder doesn't seem to like the arrow keys.
I hope this helps.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org