for the number I got 62.7 M , you would require almost 957 columns. so you
would be approach 4 worksheets (3.7) filled with numbers.

While it could be done, what is the Point?

--
Regards,
Tom Ogilvy

" wrote:

One more problem, the above macro returns more than 65536 combinations,
i tried changing the macro to shift the output column from H to I and
so on whenever the entire column is filled up but I am unable to do so.

Please help.