Using a macro on someone elses computer

[skygirl65]

I have an excel spreadsheet with a macro in it that my co-workers need to use. When I copy the spreadsheet to their computer and try to run the macro, I get the following error:
"compile error - Named Argument not found. DataOption1:=x1SortNormal"

What does this mean?

 

[SkipVought]

Hi,

They might have a different version of Excel.

Remove the last two arguments in your Sort statement.

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More![/sub]