I'm trying to test different word orders so for example "London Hyde Park" would generate:

London Hyde Park
London Park Hyde
Hyde Park London
Hyde London Park
Park Hyde London
Park London Hyde

I can input all of the words in to an array but am not sure if there's an easy way to loop through the various permutations as my strings have different numbers of words in them. I was looking at recursion but am not sure how to do this in VBA or if it's even possible.

Any ideas would be really appreciated.

Thanks