Results 1 to 3 of 3

Run Macro Many Times Automatically

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2010
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2003
    Posts
    45

    Run Macro Many Times Automatically

    Have simple copy-paste macro, but I'd like to be able to run it exactly 5,000 times without holding down Ctrl+r for 10 minutes. Would someone please show me how to modify this code so that another macro will run the 'DTC_copy_paste Macro' 5,000 times? Thanks!

    Sub DTC_copy_paste()
    '
    ' DTC_copy_paste Macro
    '
    ' Keyboard Shortcut: Ctrl+r
    '
        ActiveCell.FormulaR1C1 = "=R[3]C[120]"
        Range("A1").Select
        Selection.Copy
        Range("A2").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub
    Last edited by Greg777; 01-22-2012 at 04:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1