Posts by knonist

  • VBA Code to sort worksheets based on a pre-sorted named-range

    Re: VBA Code to sort worksheets based on a pre-sorted named-range


    Quote from jindon;656964

    Meaningless use of ArrayList.....

    Code
    Sub test()
    Dim r As Range
    For Each r In Sheets("sheet1").Cells(1).CurrentRegion.Columns(1).Cells
        Sheets(r.Value).Move after:=Sheets(Sheets.Count)
    Next
    Sheets("sheet1").Activate
End Sub


    Thanks, Have been looking for something like this for a whole day!