Results 1 to 10 of 10

Do I need a, do loop?

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Do I need a, do loop?

    Morning all,

    I have done a Macro in Excel 2003 to copy and paste infomation from one sheet to my form I have setup in another sheet.

    Can someone add to my macro so it continues copying the the data down the rows until it reaches a blank row, please

    Many thanks.

    '
    ' Macro4444 Macro
    ' Macro recorded 12/05/2009
    '
    ' Keyboard Shortcut: Ctrl+d
    '
        Sheets("Sheet 3").Select
        Range("F2").Select
        Selection.Copy
        Sheets("Side One").Select
        ActiveSheet.Paste
        Range("G42").Select
        Sheets("Sheet 3").Select
        Range("E2").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Side One").Select
        ActiveSheet.Paste
        Range("D48").Select
        Sheets("Sheet 3").Select
        Range("A2:D2").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Side One").Select
        ActiveSheet.Paste
        Range("I48").Select
        Sheets("Sheet 3").Select
        Range("G2").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Side One").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
        ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
        Sheets("Sheet 3").Select
        Range("A3").Select
    End Sub
    Last edited by adkchum; 05-13-2009 at 02:54 PM. Reason: Added Code Tags

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