This seems to me to be totaly backwards but I was using the macro recorder:

    Selection.Copy
    ActiveSheet.Next.Select
    Range("Q210").Select
    ActiveSheet.Paste
    ActiveSheet.Previous.Select
    Range("L201:L215").Select
    Application.CutCopyMode = False
What I was doing was to copy a range from sheet three L201:L215 and then paste to sheet 4 Q210. But it puts the target first and then where I want to paste from, thats kind of backwards don'tcha know