View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
obar2 obar2 is offline
external usenet poster
 
Posts: 2
Default loop each with each string

hello, i have a problem with such example, i have a string let say : "tat5"
(every in separate cell but it doesn't matter)
And what I need to do is to create loop which shift me this strinh each
element with each. I mean put ale item on every place.
So in this example shoud loop do:
1. tat5
2. att5
3. at5t
4. ta5t
5. t5at
6. t5ta
7. 5tta
8. t5ta
9. a5tt
10. 5tat
11. 5att
12. and so on....

any idea to do this ?
Thanks for any help and suggestions