PDA

View Full Version : [SOLVED] Arrange sheet names in sequence



ilyaskazi
05-19-2005, 05:49 AM
i hv following sheets in my workbook...

"SHEET1", "PAGE1", "TAB1", "SHEET2", "PAGE2", "TAB2"

coding required to arrange sheets as...

"SHEET1", "SHEET2", "PAGE1", "PAGE2", "TAB1", "TAB2"

Bob Phillips
05-19-2005, 06:18 AM
Chip Pearson has some code at http://www.cpearson.com/excel/sortws.htm

ilyaskazi
05-20-2005, 07:38 AM
thankyou...

it is solved with the help of the given web address.