How I sort worksheets by alphabet using vba Excel?

Question

0

Anonymous

Asked: August 15, 20222022-08-15T20:15:43+00:00 2022-08-15T20:15:43+00:00Computer programming

How I sort worksheets by alphabet using vba Excel?

I have an excel files which contains many sheets.

for evey sheet, the name is equal to name of student.

How Sort worksheets by alphabet using vba Excel?

thank you

0

Be the first one react

1 Answer

Leave an answer

Leave an answer
Cancel reply

Anonymous · Accepted Answer · 2022-08-15T20:17:22+00:00

hello,

try this code it will help you:

Private Sub CommandButton1_Click()
    Application.ScreenUpdating = False 'disable screen update for performance
    Dim i, j As Integer
    Dim SheetsCount As Integer
    SheetsCount = Sheets.Count
    For i = 1 To SheetsCount - 1
        For j = i + 1 To SheetsCount
            If Sheets(j).Name < Sheets(i).Name Then
                Sheets(j).Move before:=Sheets(i)
            End If
        Next j
    Next i
    Application.ScreenUpdating = True 'enable screen update
End Sub

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

Private Sub CommandButton1_Click()

Application.ScreenUpdating = False 'disable screen update for performance

Dim i, j As Integer

Dim SheetsCount As Integer

SheetsCount = Sheets.Count

For i = 1 To SheetsCount - 1

For j = i + 1 To SheetsCount

If Sheets(j).Name < Sheets(i).Name Then

Sheets(j).Move before:=Sheets(i)

End If

Next j

Next i

Application.ScreenUpdating = True 'enable screen update

End Sub

How I sort worksheets by alphabet using vba Excel?

How to Send Email in Excel Using VBA?

1 Answer

How to solve Data corruption prior to sending to F-IO ...

How to update SEO Focus keyphrase programmatically of woocommerce product?

How to Send Email in Excel Using VBA?

Morelar

William1

Maesa

Marie

Quereact Latest Questions

How I sort worksheets by alphabet using vba Excel?

Related Questions

1 Answer

Leave an answerCancel reply

Leave an answer
Cancel reply