Results 1 to 2 of 2

Repeating a Recorded Macro

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Repeating a Recorded Macro

    Hi ,This is my code.
    Help required..urgent...

    I need to repeat this n times till i find a blank cell.

    Sub Macro7()
    '
    ' Macro7 Macro
    '
    ' Keyboard Shortcut: Ctrl+l
    '
    Selection.Copy
    Sheets("OUTPUT").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Sheets("PLANT").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Selection.Copy
    Sheets("OUTPUT").Select
    ActiveCell.Offset(0, 1).Range("A1").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    ActiveCell.Offset(0, -1).Range("A1").Select
    Selection.Copy
    ActiveCell.Range("A1:A10").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    ActiveCell.Offset(10, 0).Range("A1").Select
    Sheets("PLANT").Select
    ActiveWindow.LargeScroll ToRight:=-3
    ActiveCell.Select
    Sheets("MATERIAL").Select
    ActiveCell.Offset(1, 0).Range("A1").Select
    End Sub
    Last edited by yash203; 07-11-2013 at 07:40 AM.

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