SpaaamCatcher
Technical User
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"
.Range("A1"
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 ;-)
An example of the line of code that's failing is:
Application.Goto Reference:=Worksheets("Sheet1"
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 ;-)