+ Reply to Thread
Results 1 to 2 of 2

Does anyone know if there is a way in vba to output all the permutations of different

  1. #1
    Registered User
    Join Date
    03-12-2010
    Location
    London, Engalnd
    MS-Off Ver
    Excel 2007
    Posts
    1

    Does anyone know if there is a way in vba to output all the permutations of different

    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

  2. #2
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: Does anyone know if there is a way in vba to output all the permutations of diffe

    See this:
    http://tinyurl.com/e2pyz

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1