past method of worksheet class failed

[hatzisn]

Hi all,

I am having the this problem. My paste method fails. I run my code in MS Excel 2010 and it fails
while the same time if I run it on MS Excel 2003 it works perfectly. Can anyone help? Here is my code:


Thanks in advance

Please Login or Register  to view this content.

[AB33]

Untested.

Please Login or Register  to view this content.

[HaHoBe]

Hi, hatzisn,

Please Login or Register  to view this content.

Ciao,
Holger

[hatzisn]

Hi AB33,

Thank you for your answer. The fact is that I want also the formulas and not just the values of the cells.

[AB33]

Use this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.