Do I need a, do loop?

[adkchum]

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