I think that the option is xlSortNormal (the letter "l", not the digit "1").

On Tue, 19 Apr 2005 00:31:56 -0500, lid
(robbg0326) wrote:

I encountered this same problem. I created a macro on one computer and
when I tried to use it on another terminal on our network it would not
run. I found that removing the code "DataOption1:=x1SortNormal" solved
the problem.