You have a sheet with list of Tata cars. The need is to sort them in ascending order of Model┬áname upon clicking a button. The VBA code to sort would be: – Sub Button1_Click() Range(“A:C”).Sort , Key1:=Range(“a1”), Order1:=xlAscending, Header:=True End Sub   When you run this code, it will work perfectly and sort the data. […]