this person is using an older version of excel that does not recognize that
argument. You need to remove the argument in the code as it is not
ususally necessary.

--
Regards,
Tom Ogilvy


"Papa Jonah" wrote in message
...
I have an excel app with a bunch of vba. It works as expected on my
computer
when loaded on my harddrive or when I run it from a server.
However, when a coworker runs it from the server, it works to a point.
When
my coworker tries to run another macro, he gets an error "Compile error:
named argument not found". The debugger highlights "Data option1" within
a
line that sorts some data. It works fine on my computer and when I run it
from the server.

Any ideas why this is happening?

TIA