F
FARAZ QURESHI
From the archives I was directed to:
http://www.cpearson.com/excel/sortws.aspx
I entered the entire 4 pieces of code:
1. SortWorksheetsByName;
2. SortWorksheetsByNameArray;
3. GroupSheetsByColor; and
4. Supportive code;
in a single module by:
1. Alt+F11;
2. Insert>Module;
3. Copying & pasting all the 4 parts;
Now I entered in one worksheet:
=SortWorksheetsByName(0,0,"NO")
The formula/function returns TRUE however how 2 make it work and do the
sorting of the worksheets???
http://www.cpearson.com/excel/sortws.aspx
I entered the entire 4 pieces of code:
1. SortWorksheetsByName;
2. SortWorksheetsByNameArray;
3. GroupSheetsByColor; and
4. Supportive code;
in a single module by:
1. Alt+F11;
2. Insert>Module;
3. Copying & pasting all the 4 parts;
Now I entered in one worksheet:
=SortWorksheetsByName(0,0,"NO")
The formula/function returns TRUE however how 2 make it work and do the
sorting of the worksheets???