Repeat last action

G

Guest

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!
 
M

Mallycat

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

Mallycat

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
 
G

Guest

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro repeat 2
Use Ctrl+Y to repeat last formatting action 4
Repeat key (F4, CTRL+Y) strange behaviour 5
Macro to transpose names, addresses 1
Using F4 to Repeat Last Action in Outlook 6
Relative reference? in macro 3
Macro debug - Runtime error 1004 - no data to parse? 3
Repeat function in Excel 2007 not working when sorting data 5

Top