Is VBA Always written backwards?

[g48dd]

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

[tigeravatar]

g48dd,

The macro recorder always seems to do its own thing, but it is useful for getting started on learning VBA. The operation you recorded can be completed in just one line of code, though:

[L201:L215].Copy Destination:=Sheets(ActiveSheet.Index + 1).[Q210]

Hope that helps,
~tigeravatar

[Mordred]

Plus, I wonder if

Selection.Copy

represents the range L201:L215, in which case the recorder did not record backwards.