Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

I have a range of columns that are continously being added to. The range is column B to…

  1. User

    I have a range of columns that are continously being added to. The range is column B to E. Row 1 is my Header Column B is for date entries. Is there a VBA code that can sort the table range below the header so that the Date value is from Oldest to Newest

  2. Assistant

    Yes, you can use the following VBA code to sort the table range below the header so that the date value is from oldest to newest:

    Sub SortTableByDateAscending()
        Dim lastRow As Long
        Dim sortRange As Range
        
        ' Find the last row in the table range
        lastRow = Cells(Rows.Count, "B").End(xlUp).Row
        
        ' Set the sort range from B2 to the last row of E
        Set sortRange = Range("B2:E" & lastRow)
        
        ' Sort the range by the date column (column B) in ascending order
        sortRange.Sort key1:=Range("B2"), order1:=xlAscending, Header:=xlYes
        
    End Sub
    

    You can run this code by pressing Alt + F8 to open the Macro dialog, selecting the SortTableByDateAscending macro, and clicking the "Run" button.