Thread: Arranging Worksheets using Macros

I have saved many worksheets in excel and want to arrange them in particular manner ascending or descending order. But I do not know how to do it so please show me how I can arrange these excel worksheets. Please provide me any suggestions about this.

Excel doesn’t give command to sort or order worksheet in workbook. There are many VBA functions that can use to sort or reorder worksheets. With these functions you can do following things:

• Sort few or all worksheet by name, in either ascending or descending order.

• Order worksheets by names given in array.

• Order worksheets in ascending or descending order depending on cell position in every worksheet.

• Group worksheet by tab color.

• Order worksheets depending on sheet names in series of cells.