[SOLVED] Paste Method failed (Activesheet.Paste)

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

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
>
>

You have another response in .excel

MS Excel wrote:
>
> 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

--

Dave Peterson