G
Guest
After deleting and adding worksheets, I see in VBA, the MS Execl Objects are
ordered thus:
Sheet1(First sheet)
Sheet3(Second sheet)
Sheet6(Third Sheet)
How do I rebuild this file so that the sheets are:
Sheet1(First sheet)
Sheet2(Second sheet)
Sheet3(Third Sheet)
The sheets have named lists and other references between sheets that must me
maintained. I tried the 'Move or Copy..' but that maintained the Sheet*
number. I tried to create a new workbook and cop the cells, but that lost all
the Named list references.
I'm doing this because I'm building a master template and want it 'clean'
and in order. And I'm trying to avoid redoing all the lists, etc.
Any other ideas?
Thanks,
John S.
ordered thus:
Sheet1(First sheet)
Sheet3(Second sheet)
Sheet6(Third Sheet)
How do I rebuild this file so that the sheets are:
Sheet1(First sheet)
Sheet2(Second sheet)
Sheet3(Third Sheet)
The sheets have named lists and other references between sheets that must me
maintained. I tried the 'Move or Copy..' but that maintained the Sheet*
number. I tried to create a new workbook and cop the cells, but that lost all
the Named list references.
I'm doing this because I'm building a master template and want it 'clean'
and in order. And I'm trying to avoid redoing all the lists, etc.
Any other ideas?
Thanks,
John S.