Application Fail

[jeff_kaufman]

Anyone have an idea why I am getting an applications fail with this code:

Please Login or Register  to view this content.

[berlan]

How have you defined ScrWidth and ScrHeigh?

Please Login or Register  to view this content.

[hectop]

If you execute just that snippet, ScrWdith and ScrHeight are empty.
Have you initiated them elsewhere?

[jeff_kaufman]

Yes- sorry, should tell the whole story.

The following code is written in a module:

Please Login or Register  to view this content.

I then run this code on a push of button. I am getting a fail on ".Top" and if I comment that out it then fails on ".Left" and so on.

Please Login or Register  to view this content.

[berlan]

Okay, this does however work for me:

Please Login or Register  to view this content.

[berlan]

Without any errors I mean, not sure if you actually get what you were looking for.

[jeff_kaufman]

I still get Run-time error 1004. Method 'Top' of object '_Application' failed

[berlan]

Do you have the Public variables and Declare function in a Code module?

Have you installed a 64 bit Excel?

[jeff_kaufman]

The public variables and Declare function are in a module and I have a 32 bit system.

[berlan]

Ok, then I haven't a clue :/