VBA Excel sort range by specific column

by

Try this code:

Dim lastrow As Long
lastrow = Cells(Rows.Count, 2).End(xlUp).Row
Range("A3:D" & lastrow).Sort key1:=Range("B3:B" & lastrow), _
   order1:=xlAscending, Header:=xlNo

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. How to avoid using Select in Excel VBA
  3. How do I use FileSystemObject in VBA?
  4. Is the . in .Range necessary when defined by .Cells?
  5. Run Excel Macro from Outside Excel Using VBScript From Command Line
  6. Importing text file into excel sheet
  7. Loop through each cell in a range of cells when given a Range object
  8. Checking for #N/A in Excel cell from VBA code
  9. Non-web SQL Injection
  10. Error: “Could Not Find Installable ISAM”
  11. Filling any empty cells with the value above
  12. Password hash function for Excel VBA
  13. Create a folder and sub folder in Excel VBA
  14. Aggregate, Collate and Transpose rows into columns
  15. One-dimensional array from Excel Range
  16. How to delete multiple rows without a loop in Excel VBA
  17. VBA Many buttons point to the same _Click sub
  18. Excel VBA Filter Change event handler
  19. How to suppress Update Links warning?
  20. How do we use restful APIs from Excel macros (vba)?
  21. Cannot VBA write data to cells in Excel 2007/2010 within a function
  22. Sorting a dictionary by key in VBA
  23. VBA paste as values – how to
  24. How to send email to multiple recipients with addresses stored in Excel?
  25. What are the benefits of using Classes in VBA? [closed]
  26. Writing a VLOOKUP function in vba
  27. Handle cancellation of InputBox to select range
  28. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  29. VBA: How to combine two ranges on different sheets into one, to loop through
  30. How to protect Excel workbook using VBA?

Leave a Comment