Run-Time Error 1004 - Version Problem?

[SpaaamCatcher]

I have created a fairly complex spreadsheet, but one of the most simple pieces of it is failing at the client machines. The whole thing works perfectly on my machines (office 2K or XP), but I'm not equipped for regression testing and the machines having a problem are 97.

An example of the line of code that's failing is:

Application.Goto Reference:=Worksheets("Sheet1&quot.Range("A1&quot

The error this generates is:

Run-time error 1004: Method 'goto' of object _application failed.

This all works perfectly for me, but does not work for my folks, who are on 97 - is there different syntax for the prior versions?

This is just too simple to be such a showstopper...

Help ;-)

 

[TonyJollans]

Hi SpaaamCatcher,

Can't see anything obvious and I just tried it on '97 and the syntax is the same and it works for me, so it's not as simple as you might like it to be. Sorry not to be more help at the moment.

Enjoy,
Tony

 

[RobBroekhuis]

Can you replace the goto code with activate code?
e.g.
worksheets("sheet1&quot.activate
range("A1&quot.activate

Takes one line extra code, but it's more commonly used Excel VBA code, so maybe less likely to be version-dependent.

Rob

 

[IvanMoala]

You maybe using a commandbutton from the Control toolbox ??
If so then set the buttons [Takefocusonclick] to False.



Ivan F Moala

http://www.xcelfiles.com

 

[SpaaamCatcher]

HELP! This is too simple to drive me crazy ;-) The 'Activate' statement seemed like it would be perfect, so I tested it out in a clean workbook and it worked fine. Take the same code and paste it into my workbook and it fails! WHY would such a simple statement (see below) result in a run-time error? Is there some reference missing or something?

Worksheets("sheet1&quot.Activate
Range("A1&quot.Activate

The above simple code results in a 'application-defined or object-defined' error, failing on the range.activate line.

Is there something simple I'm missing or is this a crazy mystery??

jem

 

[IvanMoala]

How are you calling the code ??
Via a Shape object button, event, or commandbutton ??

Ivan F Moala

http://www.xcelfiles.com

 

[SpaaamCatcher]

It is being called by another sub, which is initiated by a form button. But - if I just run it from within VBA, it still fails, so I suspect it's not related to how it's being called. Any chance there's something corrupt in the template?