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.



--
Regards,
Tom Ogilvy


"MS Excel" <obaid@geo-logistics.com.pk> wrote in message
news:eCOjfq9zFHA.3300@TK2MSFTNGP15.phx.gbl...
> 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
>
>