Sort a 1column table

[Belleke]

Hello,
I am looking for the shortest (fastest) VBA code to sort a one (1) colum table from A to Z.
Thanks.

 

[chirayu]

ummm... why not just record the macro?

 

[Belleke]

I know, I was just wondering if there is shorter code to sort without
things like

.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin

Is there a one liner way or so?

 

[AliGW]

Why? What benefit do you perceive? A three-line bit of VBA isn't going to take noticeably linger to run than a one-liner.

 

[Belleke]

Why?

The challenge to write short code.

 

[AliGW]

So what have you tried? Not much of a challenge if you just ask someone else to do it for you, is it?

Joking apart - I doubt you'll get it any shorter. Excel has to know what you want it to do, and there are certain instructions for sorting a column that it's going to need. How will Excel know how to sort the column if you don't tell it the sort method and orientation you want?

 

[Debaser]

Those are defaults, so simply:

    With ActiveSheet.ListObjects(1).Range
        .Sort key1:=.Cells(1), Header:=xlYes
    End With

If you insist on one line, replace the With block as necessary.