Excel 2010 Not able to run my Macro

We have a number of Macros that were built using Excel 2003 (and ran fine) that are now not able to run using Excel 2010. I'm guessing it is some type of syntax issue, but I haven't been able to find anything specific to this issue online, so that's why I'm here.

I am receiving the following error on the "Selection.Entirerow.Insert" line:

"Run-time error '1004': The information cannot be pasted because the Copy area and the paste area are not the same size and shape."

Essentially we are copying rows from one spreadsheet to another based on certain criteria.

Dim SiteCol As Range, Cell As Object
Set SiteCol = Range("B1:B65536")
For Each Cell In SiteCol
    If Cell.Value Like "MyValue*" Then
    Selection.EntireRow.Copy
    Windows("MacroWorkbook.xls").Activate
    Sheets("Import File").Select
    Range("A65536").End(xlUp).Offset(1, 0).Select
    Selection.EntireRow.Insert
    Application.CutCopyMode = False
    End If
Next

Any help is much appreciated!

Doug Walker