Moll, Benjamin wrote:
>
> How can I sort a column from B14:B24 considering alphabeticaly order?
>
>
>
> /self/.xlApp.Range(/"B14:B24"/).Sort(Key1=/self/.sht.Columns( 3 ) ,
> Order1=2, Header=1)
>
>
>
> don’t understand the meaning of key1!
>
That says to sort the data based on the 3rd column, which doesn't make
sense in your case, since you only have one column.
You should just be able to say
xlApp.Range("B14:B24").Sort(Key1=xlApp.Range("B14"), Orientation=1)
That works for me.
--
Tim Roberts, [email protected]
Providenza & Boekelheide, Inc.
_______________________________________________
python-win32 mailing list
[email protected]
http://mail.python.org/mailman/listinfo/python-win32
