Am Montag, den 05.06.2006, 10:36 +0200 schrieb Moisés Márquez Gil: > Gerrit Jasper wrote: > > > That's funny. When I record a macro and save it, and then run it, it > does everything it was told to do. > > But I would describe my actions differently. What I do is: > > Tools-Macro-RecordMacro | Select cells | -> | Do something | > -> | Stop Recording | -> | Save macro > > These are the actions I did too. Exactly ... > > - Create a new sheet > - Write date (3x3 matrix) > - Tools-Macro-RecordMacro > - Go to A1 > - Press Ctrl > - Select A1 - A3 - A5 > - Press Supr > - Stop Recording > - Save macro > - Execute macro > > This macro only supress the cell where I've the focus. It cannot supress > the cells A1 - A3 - A5 like I want.
Some actions are not tracked by the recorder. For your special task you may have more luck if you do it this way: - select the start of your range by mouse (A1) - hold the SHIFT key and navigate to the last cell of your range (A5) by keyboard How to select non consecutive cells by keyboard you have to investigate yourself, I simply don't know. ;) Have fun, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
