VBA sorting

[emily2309]

I need to be able to sort an array into numerical order when clicking a button in excel.
I have managed to sort the numbers out, however the row corresponding with the number does not also follow. The array contains four columns, and it needs to be ordered by the last one.

 

[Weaver]

Is the array a range of cells in a sheet, or a vb array?

What code are you currently using?