Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexing lists

Status
Not open for further replies.

NicolaasH

Technical User
Sep 11, 2007
38
Hi,

Is it possible to change the item number of a list (ListObjects)? I now have 12 lists on one excel worksheet, but since I did not make them in sequence the item numbers are in a random order compared to the sequence on the sheet.
I have to compare these lists to other lists in other workbooks and that would be a lot more straight forward if I can make the item indexes the same.
Is it possible to change the item index or is it read only? If possible what will be the syntax?

Thx,
Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top