VBA code to sort data in Excel example will help us to sort data in excel worksheets in Ascending or Descending order. We can use Sort method of Excel Range to sort the data. In this example we will see how to sort data in Excel Workbooks worksheets using VBA. VBA code for sorting data in excel Worksheets macro should work for all the version of Microsoft Excel 2003, Excel 2007, Excel 2010, and Excel 2013.
50+ Project Management Templates Pack
Excel PowerPoint Word
Advanced Project Plan & Portfolio Template
Ultimate Project Management Template
20+ Excel Project Management Pack
20+ PowerPoint Project Management Pack
10+ MS Word Project Management Pack
VBA code to sort the excel file
Here is the Example VBA syntax and Example VBA Macro code to sort the Excel Data. This will help you to know how to sort data in Excel worksheets using VBA.
VBA Sort Data in Excel Workbook: Syntax
Following is the VBA Syntax and sample VBA code to Sort the Data in Excel Workbook using VBA. We are using the Sort method of the Excel Workbook Range object.
Here you you can set your range into an object or you can directly use Range object like Range(“A1:D100”). And Key1 will be your Sorting Column which you wants to sort by.
Here is VBA code to sort the data in Excel by setting the range to an object:
Dim strDataRange As Range
Dim keyRange As Range
Set strDataRange = Range("Your Data Range")
Set keyRange = Range("Your Sort by Column")
Sort Data in Excel using VBA: Examples
The following VBA code is to sort the data in Excel Worksheet. This code will sort the data in Range A1 to D10 based on the First Column i.e.; A1.
Sub sb_VBA_Sort_Data() Range("A1:D10").Sort _ Key1:=Range("A1") End Sub
Instructions to run the VBA code to sort data in Excel Workbook
Please follow the below instructions to execute the VBA code to sort the excel file.
Step 1: Open any existing Excel workbook
Step 2: Enter some data in A1 to D10
Step 3: Press Alt+F11 – This will open the VBA Editor
Step 4: Insert a code module from then insert menu
Step 5: Copy the above code to sort the data in excel and paste in the code module which have inserted in the above step
Step 5: Now press F5 to execute the code
Now you can observe that your Data in Excel sheet is sorted based on the Column A.
Explained VBA Code to Sort the Excel Data :
Starting the program and sub Procedure to write VBA code to sort data in excel.
‘Here Range(“A1:D10”) is target range to sort
‘And Range(“A1”) is the sort key to Sort by
Ending the sub procedure to sort the data.
VBA to Sort the data by assigning to an Object: Examples
It is best practice to assign our target range and key Cell to temporary range objects and then sort the data. Here is the simple example to sort the data in Excel using Objects in VBA.
Sub sbSortDataInExcel() 'Delcaring the strDataRange as range store the target range to sort Dim strDataRange As Range 'Delcaring the keyRange as range store the Sort key range to sort by Dim keyRange As Range 'Assigning the target sort Range to strDataRange Set strDataRange = Range("A1:D10") 'Assigning the sort key Range to keyRange Set keyRange = Range("A1") 'Sorting the data using range objects and Sort method strDataRange.Sort Key1:=keyRange End Sub
|Excel VBA Reference||Project Management Reference|