split words in a range of cells

[ourgarden]

How can I adapt this code to include a range of cells with text strings to split?
It was designed for one cell.
I am trying to add a for/next loop to pass through the range (that varies in length).

Please Login or Register  to view this content.

b

Thanks in advance,
John

[protonLeah]

the below will mosey down column A and split the contents of each cell:

Please Login or Register  to view this content.

[ourgarden]

protpnLeah

Thankyou for your assistance. I am sorry for the length of time in returning to your reply (working w/travel 21hrs/day)

Anyway, I have been adding to the process of my original post to which it is now more complex as it is being designed to search through the column (each cell containing multiple full sentances) therefore duplicates need to be removed and the list sorted in ascending order to use on a combobox on a userform. II dont know if the organization is anywhere near porfessional however with the thought of ALLL the split words being listed before dup removal I added it into the loop each time. There are also many msgboxes used to work my way through the loops as I was having trouble referencing back to the original range and moving to the next cell. These will be converted to a progress bar as the list will be rather LARGE.

I included the code as yo u may be able to clean up my mess!

Please Login or Register  to view this content.

Again thank you for your help, it was a big step in accomplishing this project.