De: Eddie Griffiths Objet: Re: Sort sheets By Month, Date : vendredi 17 septembre 1999 21:23 Thank you. I did think of the array method, but my brain had gone to mush yesterday. too long on the PC code experimenting. Bernard GUYOT wrote in message ... >Hello Eddie. > >Please find here below a macro which do what you are searching for. I >supposed sheets are named like each month in year. >Regards. >BG > >Sub SortOnMonth() > dim Sheetarray As Variant > Sheetarray = array( _ > "July","August","September", _ > "October","November","December", _ > "January","February", _ > "March","April","May","June") > for sht = 1 to 12 > ws = Sheetarray(sht - 1) > sheets(ws).Move activeworkbook.sheets(sht) > next sht >end Sub > >Eddie Griffiths a écrit dans le message <937561649.593435@inv.ihug.co.nz>... >>Our financial year starts in July >>I need to sort the sheets >>in order of month >> >>I can sort the sheets alphabetically, but I am stumped on this one at the >>moment >> >>Advice would be appreciated.. >> >>Ta Eddie >> >> > >