Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Okay, I see the error of my ways now. Correct me if I am wrong he
As Excel promises, when you call a procedure (Sub) it will execute that procedure and then return to the next line under that Call, if there is nothing there then work is done. Basically correct. Whether to use the keyword "Call" depends on your coding. As you can see, I found it not necessary here. I failed to see that DoString was calling GetPermutations and once GetPerm's was done it would go back to DoString for next call past Get Perm's, if any, or be done. Whenever you call an external procedure, execution always returns to the caller. TxToCol is now that next call following Get Perm's. 'Splains why TxToCol works fine if ran all by itself after DoString and Get Perm's do their stuff and are out of the picture. The logic to apply here is... Get (all) Perms, then put (all) perms as TxToCols. Thanks Garry. Howard P.S. A slight re-write of that 1980's archived perm code was probably due. That's when I found it with a note by a MVP stating that the author is generally acknowledged to be unknown. I've actually seen this sample before, but never used it and so I didn't do my usual rewrite until now. Hopefully it's easier to follow what it does when stepping through!<g -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Permutations | Excel Worksheet Functions | |||
How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column | Excel Discussion (Misc queries) | |||
permutations | Excel Worksheet Functions | |||
Showing the permutations of 5 text columns in one column | Excel Discussion (Misc queries) | |||
permutations | Excel Discussion (Misc queries) |