Want to iterate code on entire column as opposed to single cell

[ilovepeanutbutter]

Hello! I am using this code:

Please Login or Register  to view this content.

EDIT (for clarification): The code takes each cell and separates every word into it's own row. An example of the results would look something like this:
outputtest1.png

However, as you can probably tell, it only works for a single cell at a time and I would need to individually select over a hundred cells. Each of the cells in the column are pretty much identical in nature and are composed of a single sentence, like so:

testexcel.png

Would appreciate any help! Thanks in advance.

[Fluff13]

Why not just use Text to columns to the data tab & use a space as the delimiter?

[ilovepeanutbutter]

Oops, sorry! I wasn't being clear enough in my post. The code iterates through a single cell and separates each word in the sentence into separate rows and not columns (delimited by a space). I just wanted to repeat the action for every cell/sentence in the column.

[Fluff13]

Oops, my fault, didn't notice you were putting it into rows, not columns.
Where do you want to put the results, because if you run that on A9, it will put the results in A9:A11.

[ilovepeanutbutter]

Yeah, what you described is pretty much where I would want the results to be For example, A15 would end up occupying A15:A17.

[xladept]

Oops - Ditto Fluff

[Fluff13]

How about

Please Login or Register  to view this content.

[ilovepeanutbutter]

Works perfectly! Thank you so much

[Fluff13]

You're welcome & thanks for the feedback.

[xladept]

Here's another attempt:

Please Login or Register  to view this content.