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
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