Repeat last action

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Teri - 13 Jul 2006 05:35 GMT

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!

Signature

Thanks
Teri

Reply to this Message

Mallycat - 13 Jul 2006 06:10 GMT

Why do you need to paste 100 x? You could just go in and edit the macro
to do what you want.

Signature

Mallycat

Reply to this Message

Teri - 13 Jul 2006 06:46 GMT

True, but still want to know why repeat doesnt work when recording macro...

Signature

Thanks
Teri

> Why do you need to paste 100 x? You could just go in and edit the macro
> to do what you want.

Reply to this Message

Mallycat - 13 Jul 2006 08:56 GMT

I don't know why, but I guess that it is disabled because the macr
recorder is trying to capture the tasks that you are actually doing
and the repeat action option is only has context relative to the las
keystroke

Reply to this Message

Teri - 13 Jul 2006 09:33 GMT

That is not the case, since it works on a colleague of mine's machine. It
must be some kind of setting or soemthing.

Signature

Thanks
Teri

> 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.

Reply to this Message

Gord Dibben - 13 Jul 2006 16:11 GMT

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

>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 to this Message