do not believe the macro that recorded by OOo's calc ....... they will not memory the position truely . so , if you do this , the macro will add the "+A1+A2" to A1 , but not to A3 . Because when you recording the macro , the current cell is A3 , but when u run it , the current cell is the cell that after twice up(From A3 , and twice up ,It's A1).
So , A1=A1+A2 , it's a death loop , and cause error . If u wanna a macro that could be used . u 'd better write it by yourself , but not the recording .... -----Original Message----- From: Jean-Michel Courat [mailto:[email protected]] Sent: Friday, August 07, 2009 2:47 AM To: [email protected] Subject: [users] 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 --------------------------------------------------------------------------------------------------- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. ---------------------------------------------------------------------------------------------------
