Sorting individual Cells

**fraz100** · 01-17-2007, 03:07 PM

Hi,

I have cells containing 2 or more words and would like to sort these words in each cell alphabetically

eg. cell contains:

mouse dog cat

change to:

cat dog mouse

thanks guys

**VBA Noob** · 01-17-2007, 03:22 PM

Hi,

This code might help. See the link below and look under VBA - For Beginners if your not sure how to add the code

Please Login or Register  to view this content.

VBA Noob

**fraz100** · 01-17-2007, 03:43 PM

Thats great!

However is there any way i can use it when selecting a group of cells.

It works on individual cells but when i try and run it for a group it returns 'type mismatch error'

thanks

**VBA Noob** · 01-17-2007, 08:36 PM

Hi,

Try this. It assumes data to sort starts in A10. Change as required

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

**fraz100** · 01-17-2007, 08:49 PM

YES!

That works. Thanks a lot for your help man. Really appreciate it!

cheers

**VBA Noob** · 01-17-2007, 08:52 PM

No problem

I'm sure the code to call the SortInOneCell could be more dynamic but still learning myself so I'm using you as a guinea pig

VBA Noob

Sorting individual Cells

LinkBack

Thread Tools

Rate This Thread

Display

Sorting individual Cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions