| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeat last action
Hi there everyone,
This seems such a simple problem, but its driving me up the wall! For some reason 'repeat last action' (Ctrl+y) doesn't work whilst I'm recording a macro (trying to repeat paste special). Macro security is set to medium, and 'repeat' works when not recording. Please help, since I need to paste special 100 x to get this macro going! -- Thanks Teri |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeat last action
Why do you need to paste 100 x? You could just go in and edit the macro to do what you want. -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560964 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeat last action
True, but still want to know why repeat doesnt work when recording macro...
-- Thanks Teri "Mallycat" wrote: Why do you need to paste 100 x? You could just go in and edit the macro to do what you want. -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560964 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeat last action
I don't know why, but I guess that it is disabled because the macro recorder is trying to capture the tasks that you are actually doing, and the repeat action option is only has context relative to the last keystroke. -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560964 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeat last action
That is not the case, since it works on a colleague of mine's machine. It
must be some kind of setting or soemthing. -- Thanks Teri "Mallycat" wrote: I don't know why, but I guess that it is disabled because the macro recorder is trying to capture the tasks that you are actually doing, and the repeat action option is only has context relative to the last keystroke. -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=560964 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeat last action
Teri
I tried it on my machine using XL 2003 CTRL + y worked and the recorder recorded the multiple CTRL + y's I can't think of a setting that would prevent the CTRL + y on your machine. Gord Dibben MS Excel MVP On Thu, 13 Jul 2006 01:33:02 -0700, Teri wrote: That is not the case, since it works on a colleague of mine's machine. It must be some kind of setting or soemthing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Action Pane is disabled when I save the document and reopen. | Charts and Charting in Excel | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
| How to make repeat long numbers shortcut ? | Excel Worksheet Functions | |||
| repeat an action in different locations | Excel Worksheet Functions | |||
Linear Mode
