alphamax
Terugkerende gebruiker
- Lid geworden
- 16 mrt 2011
- Berichten
- 2.654
- Besturingssysteem
- Windows 11 en-US
- Office versie
- Office 2007 nl-NL
Code:
[SIZE=1]Sub M_snb_alphamax()
ReDim sq(2 ^ 10, 1)
For j = 1 To UBound(sq)
For jj = 0 To Log(j) / Log(2) 'shorter loops
If (j And 2 ^ jj) <> 0 Then 'logic
sq(j, 0) = sq(j, 0) & Chr(65 + jj)
sq(j, 1) = sq(j, 1) + Array(20, 12, 9, 15, 6, 20, 14, 7, 6, 2, -999)(jj) '-999 prevent error in only last line
End If
Next
Next
Cells(1, 18).Resize(UBound(sq), 2) = sq
End Sub
[/SIZE]
Laatst bewerkt: