Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Sheets in Workbook
Hi,
I have a workbook which has around 450 sheets and unordered. All the sheets are named using integer strings viz..1, 2, 5, 6, 11, 56 etc. New sheets will be added at the end. I want to order these sheets using Excel macro or VBA. Could you please let me know how I could achieve this? Requirement is Current order of workbook sheets 1, 5, 3, 7, 10,.9,15, 20,22, 2 etc. After running the macro, I need the sheets to be in the order 1,2,3,5,7,9,10,15,20,22 etc. Thanks in Advance, Mnj 78 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Sheets in 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 which has around 450 sheets and unordered. All the sheets are named using integer strings viz..1, 2, 5, 6, 11, 56 etc. New sheets will be added at the end. I want to order these sheets using Excel macro or VBA. Could you please let me know how I could achieve this? Requirement is Current order of workbook sheets 1, 5, 3, 7, 10,.9,15, 20,22, 2 etc. After running the macro, I need the sheets to be in the order 1,2,3,5,7,9,10,15,20,22 etc. Thanks in Advance, 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 | |||
Sorting Sheets in a workbook | Excel Programming | |||
Sheets select method fails when workbook is opened by another workbook | Excel Programming |