A
Anand Nichkaode
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
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