Results 1 to 25 of 25

Make recorded macro loop

Threaded View

cowannbell Make recorded macro loop 01-04-2013, 02:38 PM
arlu1201 Re: Make recorded macro loop 01-04-2013, 02:46 PM
cowannbell Re: Make recorded macro loop 01-04-2013, 02:51 PM
cowannbell Re: Make recorded macro loop 01-04-2013, 02:53 PM
arlu1201 Re: Make recorded macro loop 01-04-2013, 02:55 PM
cowannbell Re: Make recorded macro loop 01-04-2013, 03:10 PM
AB33 Re: Make recorded macro loop 01-04-2013, 04:58 PM
cowannbell Re: Make recorded macro loop 01-08-2013, 10:34 AM
cowannbell Re: Make recorded macro loop 01-08-2013, 10:34 AM
AB33 Re: Make recorded macro loop 01-08-2013, 11:25 AM
cowannbell Re: Make recorded macro loop 01-08-2013, 01:50 PM
AB33 Re: Make recorded macro loop 01-08-2013, 02:18 PM
cowannbell Re: Make recorded macro loop 01-08-2013, 02:42 PM
cowannbell Re: Make recorded macro loop 01-08-2013, 02:48 PM
AB33 Re: Make recorded macro loop 01-08-2013, 02:56 PM
cowannbell Re: Make recorded macro loop 01-08-2013, 03:04 PM
AB33 Re: Make recorded macro loop 01-08-2013, 03:30 PM
cowannbell Re: Make recorded macro loop 01-09-2013, 08:22 AM
AB33 Re: Make recorded macro loop 01-09-2013, 04:13 PM
cowannbell Re: Make recorded macro loop 01-10-2013, 03:35 PM
AB33 Re: Make recorded macro loop 01-10-2013, 03:49 PM
cowannbell Re: Make recorded macro loop 01-11-2013, 08:39 AM
AB33 Re: Make recorded macro loop 01-11-2013, 08:55 AM
cowannbell Re: Make recorded macro loop 01-11-2013, 09:43 AM
AB33 Re: Make recorded macro loop 01-11-2013, 09:53 AM
  1. #1
    Registered User
    Join Date
    06-22-2005
    Posts
    19

    Make recorded macro loop

    I have recorded the below macro but I need it to loop until there is nothing left in the last column.

    Can anyone assist?

    Thanks,

    Sub ARS2013test()
    '
    ' ARS2013test Macro
    '
    ' Keyboard Shortcut: Ctrl+t
    '
        ActiveCell.Offset(0, 1).Range("A1").Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Cut
        ActiveCell.Offset(0, -3).Range("A1").Select
        Selection.End(xlDown).Select
        ActiveCell.Offset(1, 0).Range("A1").Select
        ActiveSheet.Paste
        Selection.End(xlUp).Select
        ActiveCell.Offset(-1, 0).Range("A1").Select
        Selection.End(xlToRight).Select
        Selection.Copy
        ActiveCell.Offset(1, -2).Range("A1").Select
        Selection.End(xlDown).Select
        ActiveCell.Offset(1, 0).Range("A1:A31").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Selection.End(xlUp).Select
        ActiveCell.Offset(0, 2).Columns("A:A").EntireColumn.Select
        Application.CutCopyMode = False
        Selection.Delete Shift:=xlToLeft
        ActiveCell.Offset(1, -1).Range("A1").Select
    End Sub
    Moderator's Edit: Use code tags when posting code. To do so in future, select the code and click on the # icon at the top of your post window.
    Last edited by arlu1201; 01-04-2013 at 02:45 PM.

Thread Information

Users Browsing this Thread

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

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