Copy/Paste With Single Line Using VBA (2007)

I had the following code that worked great with Excel 2003, but I receive an error with Excel 2007.


Dim Master As Workbook
Set Master = Workbooks("Master.xls")

For Each wb In Workbooks
wb.Activate
If wb.Name Like "S04*" Then _
If Not Range("A2") = Empty Then _
Range(Cells(Rows.Count, 1).End(xlUp), Range("A2")).EntireRow.Copy _
Master.ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1)
Next wb

I receive error 1004 "application defined or object defined error" when it tries to paste to the "Master" sheet using the the above lines.

Is there something in the formatting that has changed with 2007? I'm guessing I have to slightly change the line in bold.