Hi,

I have a Excel 97-2003 workbook. And on one of the sheets there is a Table
inserted from Data-Table which does some interest calculation.

When this workbook is opened in Excel 2007 following code is run Excel
crashes.

Whereas in Excel 97 I get "Method PasteSpecial of object Range failed" error
for the first time. If I stop and re-run the code formulas for the table are
removed.

Code:
Cells.Select

Selection.Copy

Selection.PasteSpecial xlValues

Cells(1, 1).Select

Does anybody have any idea about this.

Pls. let me know if you want to have a look at the workbook.

Thanks in advance.

-Anand