Sort fields in the current selection

[88rizer]

I would like a macro to sort fields in the current selection ( selected before running macro). tks

 

[My Aswer Is This]

Re: 88rizer

Try this:

Sub Sort_Me()
'Modified 4/28/2019 3:25:03 PM  EDT
Application.ScreenUpdating = False
Selection.Sort key1:=Selection, order1:=xlAscending, Header:=xlNo
Application.ScreenUpdating = True
End Sub

 

[Macropod]

Re: 88rizer

88rizer: Please read The Forum Guidleines, especially Guidline 4: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html. As a thread title, '88rizer' doesn't qualify as "a meaningful title that is specific to your question".

 

[My Aswer Is This]

Re: 88rizer

I thought the thread Title was:

Sort fields in the current selection​

 

[Macropod]

Re: 88rizer

Have a look at the headings for the last 3 posts. I changed the title after posting...

 

[88rizer]

Re: Sort mulltiple fields in the current range (selected prior to running macro)

"I would like a macro to sort multiple fields in the current range selection ( selected before running macro). tks
range can be between c8:j350.
I am tryling to sort checks, deposits and dates for each month out of a years spread sheet.

 

[My Aswer Is This]

Re: Sort mulltiple fields in the current range (selected prior to running macro)

I suggest you try using the Macro recorder. You have not provided specific details.

Like how to sort. What column in the selection is the range sorted by

And you earlier said selection you did not mention specific range

See you have to tell the script which column in selection to sort by.

I have no way of knowing.

Try using the Macro recorder to do your sorting then Modify it to your needs if you plan to change the selection each time