Mac system 9 emulator. Column V is an empty column in the middle of data -that means that Excel itself cannot see your data as a single range. This is the way to get VBA sort ranges to expand automatically: - 3 named ranges. VBA sort range by selcted column You are welcome. Thanks for the rep. Register To Reply.

VBA code to sort data in Ascending Order Here is the Example VBA syntax and Example VBA Macro code to sort the Excel Data in Ascending Order. This will help you to know how to sort data in Excel worksheets using VBA in Ascending Order. VBA Sort Data in Ascending Order: Syntax Following is the VBA Syntax and sample VBA code to Sort the Data in Ascending Order using VBA. We are using the Sort method of the Excel Workbook Range object and sort order as Ascending. Range.Sort Key1:=Range('A1'), Order1:=xlAscending 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.

And we can specify the sort order using Order1. 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') strDataRange.Sort Key1:=keyRange, Order1:=xlAscending Sort Data in Ascending using VBA: Examples The following VBA code is to sort the data in Ascending in Excel Worksheet. This code will sort the data in Range A1 to D10 based on the First Column i.e.; A1. And in Ascending order.

Sub sb_VBA_Sort_Data_Ascending() Range('A1:D10').Sort _ Key1:=Range('A1'), Order1:=xlAscending End Sub Instructions to run the VBA code to sort data in Excel Workbook in Ascending Order 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 the Data in Excel sheet is sorted in Ascending order based on the Column A.