Prev: create overtime spread sheet
Next: One step paste of XLS file name in one of its own cells
From: Mike H on 27 May 2010 16:50
Hi,

Alt+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and
paste the code below in and run it

Sub Sortem()
For x = 1 To Worksheets.Count
For y = x To Worksheets.Count
If UCase(Sheets(y).Name) < UCase(Sheets(x).Name) Then
Sheets(y).Move Before:=Sheets(x)
End If
Next
Next
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Anita" wrote:

> The only way I know is to drag and drop but it's time consuming. Is there an
> easier way?
 | 
Pages: 1
Prev: create overtime spread sheet
Next: One step paste of XLS file name in one of its own cells