Sort using CustomList - error

[Shurov]

I need to sort a list using custom sort order
I have created CustomList with

Please Login or Register  to view this content.

After that I add common Sort function:

Please Login or Register  to view this content.

but my code crushes on .SortFields.Add line with Run-time error '448': Named argument not found. I tried to google on this error, but without any result
What am I writing wrong in .SortFields.Add arguments?

[karedog]

Hi,

You should use this as a workaround :

Please Login or Register  to view this content.

This is a bug confirmed by microsoft, read it here :
http://support2.microsoft.com/default.aspx?kbid=134913

Similiar problem :
On google groups

Regards

[Shurov]

karedog, thanks for your reply!

I have already tried adding +1. Actually, initially my code was with that "+1" (copied from some forum as is) and afterwards I deleted it.
Moreover, that bug was present only till Office 2000 according to Microsoft site, while I have Ofiice 2010.

Anyway, this thing was not the case...
My sorting was written like

Please Login or Register  to view this content.

meanwhile on many forums I saw sorting, written in 1 line:

Please Login or Register  to view this content.

After changing my sorting from "With Range() ... " to 1-line code, everything worked!

However, still do not know, what the differences are

Thanks again!

[karedog]

Dear Shurov, many thanks for the reputation point.

The one line code sort is a range method, while the above multiline sort is an object of a worksheet.

Now since you mention it, I just recalled it :
One difference between them is, for the range method, the parameter name is OrderCustom, while for the sheet object it is CustomOrder
So it is a typo. Yes, it is confusing why Microsoft doing something like this.

So, if you willing to try the first code, try to change the parameter to CustomOrder since this is the parameter for the worksheet sort object.

Regards

[Shurov]

Dear karedog, thanks for such exhaustive explanation!
After changing words order in "OrderCustom" in multi-line sorting function it worked
However, I have left 1-line function in my code

Thanks again!