Macro to Put Rows of Data in Alphabetical Order

[Orangeworker]

Hello,

Could someone here create a macro that will put the data below in alphabetical order (the data is in a row, all caps, and separated by a comma. I have many rows of data. Just need each row sorted by first name. Here's an example:


MIKE J RAPSON, DEVIN M BAZEMORE, CHRISTOPHER ALLEN BICKNELL, LEO CHRISTOPHER


Thanks

[Orangeworker]

Here is some code. How can I make it select all rows C - G instead of just row 3?

Please Login or Register  to view this content.

[mewingkitty]

Should be able to just change the "C3:G3"'s to "C3:G100" or whatever you want the range to be.

mew!