Would it be possible to hack into your original macro and insert an index
that could be used in your sorting macro? (Does it use a "for each"
construction?) Or perhaps your list-populating macro could also perform a
sort?
I apologize for not being able to answer directly, but perhaps you can find
a work-around.

"Jasper" wrote:

I used another macro that put the names of 146 different sheets (in the
same workbook) in the listbox. i put them in a listbox so i can double
click on the name so i jump to the corresponding sheet (i know i can
use the arrows next to the name of the most left sheet to do this, but
i want to use a listbox).

i need to last item in the listbox so i can use a loop to sort them. if
i dont use the last item number (128 in this case) but make enter (for
example) 150 as the end of the loop, then by the time the loop reaches
item 129 i get an error stating there is no item 129 (while obviously
there is...).

i hope that clarifies?