View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default Perfect Macro Combinations


It take about 5 seconds for each column of 65536 results.
With only 253 columns available on the first sheet it will take about
21 minutes to fill is.

Are you sure you want to get the enormous number of results?


HI RadarEye , thank you for your Macro , i think I'll learn a lot
from it ! My big problem was that i couldn't get the result in another
columns , and Gary"s Student gived me the perfect solutions ;
to get the enormous number of results it isn't so important for me ,
i needed some few miliones of combinations ; in A1:A90 you can
type references for a function and then you can very easy transform
this references in functions . For eg : how long take you to make
65536
of Count function with the references of this function taken 90/15 in
combinatoric order ?
Imagine you need them very strong !..
With Macro Combin90 you can do this in 3 minutes ; I looked for
this thing many month .I think i'll post another subiect about :
,,How to make (if this thing can be create) an formula/function [eg:
Count],
which with autofill action , to fill the cells with combinatoric
references
based on the first reference you put in first cell ?" [mean :
B1,B2.....B14,B15]
I think is not a easy thing , ... here is the time of teachers ! ...

RESPECTFULLY FOR ALL