Wheels using excel ?? Why Not!

Reply #2

wpb — Wed, 04 Jan 2006 02:07:17 GMT

Thank you for posting this site lottoloot, I was just trying to figure out how to get excel to give me all combo's to a four digit number.

Reply #1

lottaloot — Wed, 04 Jan 2006 02:02:31 GMT

Care of http://www.ozgrid.com/forum/showthread.php?t=42056 highlight=permutationsOption Explicit 'Written by Myrna Larson - Microsoft Excel MVPDim vAllItems As VariantDim Buffer() As StringDim BufferPtr As LongDim Results As Worksheet Sub ListPermutations() Dim Rng As Range Dim PopSize As Integer Dim SetSize As Integer Dim Which As String Dim N As Double Const BufferSize As Long = 4096 Set Rng = Range(Range( A1 ), Cells(Rows.Count, A ).End(xlUp)) PopSiz... [ More ]

Wheels using excel ?? Why Not!

lottaloot — Wed, 04 Jan 2006 01:54:56 GMT

Found a great VBA that allows you to create wheels or permutations as they are called. Here's what you do. Place C in A1 3 in A2And the numbers that you want in A3: down to whateverRun the code in order to see that wheels...There will be another sheet added to your workbook.