6 Number Combination

Hi,
I copied this VBA code from a search to help with 6/49 lotto. It is suppose to do the following:
It allows an input (in Column B)of an x set of numbers (e.g. 1,2,3,4,7,0,42,34,12, etc.)
and it should give you all possible 6 number combinations (e.g. 3,7,12,34,1,2) and so forth.
When i run it, it gives mismatch errors.
Can anyone help me figure it out. Or is it better to start from scratch?
Thanks

Please Login or Register  to view this content.

from mr excel where this code was posted
http://www.mrexcel.com/forum/excel-q...binations.html
an amendment was made the code is missing 2 lines at the top it should read

Please Login or Register  to view this content.

not when i run it