How to sort a range

[dpbarry]

Hi Folks.

I'm passing over control of a spreadsheet to a colleague as I am temporarily bowing out of the Rescue Services I have been involved with for over 17 years.

In order to make the SS as easy as possible to use, I'm adding in buttons to perform certain tasks that I manually did.

One button I'd like to add in is for a sort. Its part of a worksheet where vlookup on another worksheet references it - and the list has to be in alphabetical order. I'd like when the user clicks on a button, it sorts from A2 to E25 and by column A.

Is that possible to do?

Regards

Declan

 

[VoG]

Try assigning this to a button

Sub srt()
Range("A2:E25").Sort Key1:=Range("A2"), Order1:=xlAscending, _
        Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub