I have some VBA code (see below) where I am copying a fixed selection from
one workbook (which the user has selected), into the next empty row in a
different workbook (where the macro is located).


Sheets("National").Select
Range("A6:X21").Select
Selection.Copy

Windows("Diagnostics 2010-2011.xls").Activate
Sheets("C-National").Select
Selection.paste

However, I get a run time error (438) on the paste command when I try to run
it.

Any suggestions, as I am new to VBA