以下是引用搁浅2008在2010-2-11 9:38:00的发言: Sub tt() Dim arr Dim arr2 Dim i As Long Dim j As Long Dim m As Long Dim d As Object Set d = CreateObject("scripting.dictionary") Do m = Int(Rnd() * 9 + 1) d(m) = "" Loop Until d.Count = 9 arr = d.keys ReDim arr2(1 To 3, 1 To 3) For i = 1 To 3 For j = 1 To 3 arr2(i, j) = arr(i * 3 + j - 4) Next j Next i Range("A1:C3") = arr2 End Sub
Dim x ' ' ' For Each x In arr2 x = arr(i) i = i + 1 Next x 我想这样替换蓝色的部分,为什么不行呢[em03] |