Custom List Number

S

scott

I created a macro that adds a custom list to a user's computer.
Another part of the spreadhseet references the list by a number:

(election.Sort Order1:=xlAscending, Type:=xlSortLabels,
OrderCustom:=6, _
Orientation:=xlTopToBottom).

Does anyone know how to grap the custom list number after it is
entered so i can put it into a variable. I am afriad that list #6 for
example may not be the same for everyone else. Thanks.

-Scott
 
T

Tom Ogilvy

On way would be to loop through the list and examine each list while
maintaining the count. When you find yours, store the number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top