|
这段代码在sheet9为非激活状态不能正确执行,为什么?
Sub changePosition()
Dim rRow As Long
Dim LRow As Long, suoYouShuJu, linShiShuJu(1 To 8), suiJIShu
Dim suoYouShuJuMax As Integer
Dim i As Integer, j As Integer, k As Integer
'ActiveSheet.Parent.Worksheets("sheet9").Active
rRow = Worksheets("sheet9").UsedRange.Row
LRow = rRow + Worksheets("sheet9").UsedRange.Rows.Count - 1
suoYouShuJu = Worksheets("sheet9").Range(Cells(1, 1), Cells(LRow, 6))
suoYouShuJuMax = UBound(suoYouShuJu)
For i = 1 To suoYouShuJuMax
suiJIShu = (Rnd() * ((suoYouShuJuMax - i + 1) - 1) + 1) \ 1
For j = 1 To 6
linShiShuJu(j) = suoYouShuJu(suiJIShu, j)
suoYouShuJu(suiJIShu, j) = suoYouShuJu(suoYouShuJuMax - i + 1, j)
suoYouShuJu(suoYouShuJuMax - i + 1, j) = linShiShuJu(j)
Next j
Next i
Worksheets("sheet2").Range("a1").Resize(6) = suoYouShuJu
End Sub
|
|
|