Dear Experts,

I'm at entry level in VBA and usually can only modify recorded macros.

Book1 with sheet named Transaction
Book2 with sheet named TX

The codes is intended to copy variable number of rows from Book1 to Book2, but fails at line 7 :

1 Windows("Book1.xls").Activate
2 Sheets("Transaction").Select
3 Rows("9:9").Select
4 Range(Selection, Selection.End(xlDown)).Select
5 Selection.Copy
6 Windows("Book2.xls").Activate
7 Sheets("TX").Select
8 Range("A9").Select
9 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
10 :=False, Transpose:=False

Grateful if any can help. Thx so much!