Paste Method failed (Activesheet.Paste)

[MS Excel]

Hi,

While using Activesheet.Paste in a newly created book through workbook.add
function, I got following message
"Paste method of workbook class failed."
To my amazement, the same was working perfectly in MS EXCEL XP but when
upgraded to Excel 2003 its creating problem..

Any idea.?

Syed

 

[Tom Ogilvy]

I am happy to report the command works fine in xl2003.

Demo'd from the immediate window:
worksheets("Sheet2").Range("A1").Resize(3,3).copy
Activesheet.Paste
? Worksheets("Sheet2").Range("A1").Value
792
? activecell.Value
792

Now the challenge is to identify what environmental/situational aspect
specific to your situation is causing the problem.

 

[Dave Peterson]

You have another response in .excel

Hi,

While using Activesheet.Paste in a newly created book through workbook.add
function, I got following message
"Paste method of workbook class failed."
To my amazement, the same was working perfectly in MS EXCEL XP but when
upgraded to Excel 2003 its creating problem..

Any idea.?

Syed