Excel VBA sort string macro

Question

I have a word in each row that I want to sort. It does not matter which of the words comes first as long as they are sorted. Below is an example of my excel sheet where I have replaced the word with one single letter instead. Is it possible to write a macro to help me to sort?

Thanks in advance!

Column 1

x

y

x

z

x

y

start recording a Macro, do your sorting with excel (Data-> Sort) and when you're done stop the macro. Finally open VEB editor (ALT+F11) and see the code — user3598756
– user3598756, Commented Oct 22, 2016 at 16:20

Aditya Pansare · Accepted Answer · 2016-10-22 18:21:38Z

1

use below line

Range("A1").Sort key1:=Range("A1"), order1:=xlDescending, Header:=xlYes

answered Oct 22, 2016 at 18:21

Aditya Pansare

1,1329 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA sort string macro

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related