Hi , and a good day programmers !


I need strong something very strange and not too usual !! I have
this :

ex: 1

{1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|0|0|0|0|0|0|0|0|0|0 |0|0|0|0|0|0|0|0|0|0|
0|0|0|0|0|0|0|0|0|0}

which is an array in a formula ; for a more clear look , I write down
simplified , (this ,only for
example) :

1 1 1 1 1 0 0 0 0 0
1 1 1 1 0 1 0 0 0 0
1 1 1 1 0 0 1 0 0 0
1 1 1 1 0 0 0 1 0 0
1 1 1 1 0 0 0 0 1 0
1 1 1 1 0 0 0 0 0 1
1 1 1 0 1 1 0 0 0 0
1 1 1 0 1 0 1 0 0 0
1 1 1 0 1 0 0 1 0 0
etc .

I have like in first example , 45 of numbers , 15 of 1 and 30 of 0 ;
I don't know what kind of VBA macro I must use : macro for return
combinations , or permutations , or arrangements ! !
....because , when number 1 must move at every combinations (or
arrangements ) of 45 numbers/variants , in it's place must replace
with 0 ;
__________________________________________________ _______________
In the 45 cells with which macro shall work , the value in every cell
shall look so :

|0 or 1| ; I don't know how them must declare !!
Dim i1 As Long ..... I don't know if it works , because maybe this
kind of values
aren't recognise like a number value !!

Any sugestions will be helpfull
It's a great thing for me to know and only what kind of macro I must
try : combine ,
permutations or arrangements !