How Do I Sort Worksheets which is between worksheet name Start to Worksheet Name Finish. there are 10 worksheets between Sheet "Start" To Sheet "Finish".
I don't have much knowledge about VBA but I had written Code from different code. but it is not working. Please Help Me out on this.
Dim S As Integer, SS As Integer, Start As Integer, Finish As Integer
Start = Worksheets("Start").Index
Finish = Worksheets("Finish").Index
If (Finish - Start) > 2 Then
For SS = Start + 1 To Finish - 2
For S = Start + 1 To Finissh - 2
If Worksheets(S + 1).Name < Worksheets(S).Name Then Worksheets(S + 1).Move before:=Worksheets(S)