Hello to all. I need VBA macro code for the following problem.
1. There are nine english alphabets ( r,s,t,u,v,w,x,y,z)
2. They should be used to fill the cells in 12 columns A,B,C,D,E,F,G,H,I,J,K,L in each row.
3. In a row an alphabet can appear only once. But all the nine alphabets should be in a row
4. A cell may contain all the nine alphabets,or 8alphabets,7,6,5,4,3,2,or 1alphabet.
(Order does not matter. r,s,t -t,s,r, -s,r,t-s,t,r all are equal) . A cell can be blank also.
I need a code to fill the cells in all possible combinations and distributions. For example If I want to find a row in which column A is blank, --6 alphabets r,u,z,t,,x,w in B,-- C,D, Blank,- -'s' in E, -'v' 'y'in F,--G,H,I,J,K,L,Blanks-- one such row should be there.
As I do not know permutations and combinations, I do not know how to write the code. But I can use a witten code. Will some one help me?