View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default Sort collection string keys

Thanks Tom. In that case I'd better go back to where the collection gets
built add an duplicate array I suppose.

Thanks again

Best regards

John
"Tom Ogilvy" wrote in message
...
to the best of my knowledge, you can't retrieve the index keys.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Hi there,

I've got a collection that I want to sort and put into a listbox. The
collection is a series of cell references (delimited with a comma) and

each
item has a string key on which I want to sort.

So how can I run through my collection to pull out all the index keys?

Thanks in advance

Best regards

John