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.