Method 'top' of object 'plotarea' failed

[leafbiffen]

Hi

Cant get this code to work.
I havent written it myself, it's someone that worked on our company several years ago.

It has worked says my collegs.

I think it was written an worked with excel 2003,

This part shall position the chart and its objects in worksheet 1
It works until its time to arrqange the plotareaobject and I can't think out why.
I know to little VBA. I just have to make this sheet work.

I hope someone can help me...

Please Login or Register  to view this content.

[Andy Pope]

The code works in xl2007 and xl2010.

Try checking for missing references in VBE. Tools > References.

Or post example workbook where the error is replicated.

[JosephP]

do you have all the service packs and patches applied to office?

[leafbiffen]

This is the referenses i got in VBE.
I dont know if that is enough.

[Andy Pope]

can you post the file? replace any confidential data with random data

[leafbiffen]

Hi it is my company-computer and we are not allowed to update anything. We get the updates and servicepacks from our companys computer-guys.
This code must work on everybodys computer.

[JosephP]

the point is that is should which is why I ask if you have them installed. I believe that without sp2 installed there are a lot of chart problems in 2007-you may need to turn screenupdating back on if it was turned off in the code that calls the function, or read the top property before setting it

Please Login or Register  to view this content.

for instance