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:[email protected]] Sent: Thursday, August 06, 2009 2:47 PM To: [email protected] 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.) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
