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

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

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

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

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

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.