You select a range (Range("A52:E92").Select).But try to paste it into a cell (A1).Since you know the size of your range, I would suggest selecting a rangeof similar size in the new spreadsheet to match the range selected.