Sort using CustomList - error

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

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!

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