Editing code to show common four-word combinations in a column

[Glayva]

Thanks.

Try this:

Please Login or Register  to view this content.

I've just managed to use this to find common words and two- and three-word combinations in a spreadsheet showing questions entered in a search box (Thanks @shg). It was my first time using vba code but it worked fine and dandy.

However I would also like to show common four-word combinations. Can someone advise me which part of the code influences how many words can be included when looking for common word combinations, and how to adjust it so I can see common four-word combinations too?

Thanks

G

[StephenR]

I think you just add this to the end of Test:

Please Login or Register  to view this content.

[Glayva]

I think you just add this to the end of Test:

Please Login or Register  to view this content.

Aha! So simple! Thank you

G

[snb]

alternative:

Please Login or Register  to view this content.

[Glayva]

alternative:

<code>

Thanks @snb. I am new to excel coding. What's the main difference between the two examples?

Thanks

G