rolo
Member
Hello,
I use Excel 2016
Suppose I need to sort my table by column 1 - ascending
If I record a sort action, the recorded code is too long.
I need to know if this shorter sort code is safe:
Thanks!
I use Excel 2016
Suppose I need to sort my table by column 1 - ascending
If I record a sort action, the recorded code is too long.
I need to know if this shorter sort code is safe:
Code:
Range("MyTableName").Sort _
Key1:=Range("MyTableName").Cells(1), Order1:=xlAscending, Header:=xlYes
Thanks!