possible combination of names [SOLVED]

lambuhere1 · May 12th 2003

Hi

I would like to have your kind help in getting various names using different characters. Lets say for e.g., a husbands name is ABC and wifes name is DEF. I would like to use a combination of characters to get different possible names using both ABC and DEF... like ABCDEF, ABCDFE etc. I know it involves a bit of coding, But I am unsucessful till date.

Could anyone be kind enough to help me in this?

Thanks

Ram P

Dave Hawley · May 12th 2003

Hi Ram

Here is one I go from the Web some time back. See code for due credit.

Dave Hawley · May 12th 2003

Better use this one. I couldn't open the Zip file.

lambuhere1 · May 12th 2003

Dave

Thanks a lot for your kind help. I do like this. I did try to understand the code. But it works only for 9 characters. Is there any way we can increase the number of characters to say 10 or 15 max?

Thanks

Dave Hawley · May 12th 2003

Hi Ram

You could, BUT it will take a long long time to permute that many characters. It's like the Chess board trick where you place one cents on square 1 and keep doubling at each square. After 64 moves you end up with one VERY LARGE number!

The line you would change is:

Code

.Buttons("buOK").Enabled = (PermutCount [b]<= 2 ^ 14[/b]) Or  _
.CheckBoxes("cbExisting") = xlOn

Not only would it take a month or more for 15 characters, but it wont fit into one columns (only 64536 rows), possibly not even on one sheet.

lambuhere1 · May 12th 2003

Dave

Thanks for your help.

I think Now I need to refine the code to inculde the data in subsequent columns if data rows exceed 65536.

THanks for your help.

I hope you are doing fine in Australia !!

lambuhere1 · Dec 13th 2004

Re: possible combination of names [SOLVED]

Dave, I lost all my files recently. I was looking at the same requiement again. Do you still have the link ?

Thanks

Ram P

possible combination of names [SOLVED]

Participate now!

Share