Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Sheets in a workbook
Hi,
I have a workbook in which there are around 450 sheets are are named as 1, 2, 3 etc. These sheets are unordered and the workbook is updated to add more sheets and are placed at the end. I want to sort these sheets and also, everytime a new sheet is added, I want them to be placed at the right position in the workbook. Could you please let me know if I can achieve this usign Excel Macro or VBA ? Ex: Currently the sheets are in the order 1, 5, 3, 9, 7, 20, 11, 22,19 etc. And after sorting the sheets should be in the order 1,3,5,7,9,11,19,20,22 etc. Regards, Mnj 78 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Sheets in a workbook
Hi
see your other post P.S.: please don't multipost -- Regards Frank Kabel Frankfurt, Germany "Mnj 78" schrieb im Newsbeitrag ... Hi, I have a workbook in which there are around 450 sheets are are named as 1, 2, 3 etc. These sheets are unordered and the workbook is updated to add more sheets and are placed at the end. I want to sort these sheets and also, everytime a new sheet is added, I want them to be placed at the right position in the workbook. Could you please let me know if I can achieve this usign Excel Macro or VBA ? Ex: Currently the sheets are in the order 1, 5, 3, 9, 7, 20, 11, 22,19 etc. And after sorting the sheets should be in the order 1,3,5,7,9,11,19,20,22 etc. Regards, Mnj 78 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Sorting Sheets in a Workbook | Excel Programming | |||
Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
Sorting sheets | Excel Programming |