Repeating macros x times?

Joined
Sep 14, 2009
Messages
1
Reaction score
0
I'm very new to all of this, so please forgive me if there's an obvious answer (I've been Googling for a while, but I'm not up on all the vocab). I've made a macro and want it to repeat ten or 20 times each time I use shortcut key, but I'm not having any luck. I'm on Excel 2003, and I want to make the following code repeat:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/14/2009 by Username
'
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.Offset(1, -13).Range("A1:M1").Select
Selection.Cut
ActiveCell.Offset(-1, 13).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(2, 0).Range("A1").Select
End Sub
 

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

Top