macro to sort selected group of cells

[RedOctoberKnight]

Good Morning,

First off, I'd like to thank everyone who has helped me in the past. I've learned so much from everyone on here.

I'd like to know if there was a way to use a macro that could sort a select group of selected cells by (in this case "time" in ascending order) in column "J". So for example if I select all the data from H4:O24, Id like it to sort it by the time in column J.

Any help would be much appreciated. Thanks!

 

[offthelip]

This will sort the range you specifed;

Sub test()
   Set myrange = Range("H4:O24")
    Set Sortkey = Range("J4:J24")
    myrange.Sort key1:=Sortkey, order1:=xlAscending, MatchCase:=False, Header:=xlYes

End Sub