Change cell from "A,E,D,C" to "A,C,D,E"

**london7871** · 10-11-2011, 05:02 AM

How to change cell with value "A,E,D,C" to ascending order "A,C,D,E" by VBA?

**MickG** · 10-11-2011, 05:38 AM

Try this:-
Data "A1" Resul;ts "A2".

Please Login or Register  to view this content.

Regards Mick

**london7871** · 10-13-2011, 12:10 AM

Dear Mick,

Thanks.

Regards.

**MarvinP** · 10-13-2011, 12:27 AM

Hi london7871,

Look at http://www.ozgrid.com/VBA/sort-array.htm and the Sort Array routine.

Look to see if Arrays have the first element as the zero index for why the above didn't sort the "z" correctly.

**MickG** · 10-13-2011, 07:14 AM

Sorry try this:-

Please Login or Register  to view this content.

Mick

Change cell from "A,E,D,C" to "A,C,D,E"

LinkBack

Thread Tools

Rate This Thread

Display

Change cell from "A,E,D,C" to "A,C,D,E"

Re: Change cell from "A,E,D,C" to "A,C,D,E"

Re: Change cell from "A,E,D,C" to "A,C,D,E"

Re: Change cell from "A,E,D,C" to "A,C,D,E"

Re: Change cell from "A,E,D,C" to "A,C,D,E"

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions