请问下,下边代码中什么地方间传递了C4这个变量的,如果变量的单元格改变应该如何改啊,谢谢! Sub test() Dim i As Integer Dim num() As Variant Dim res As Variant, res1 As String Dim n As Integer For i = 1 To 6 ReDim Preserve num(1, i) num(0, i) = Cells(i + 4, 2) num(1, i) = Cells(i + 4, 3) Next i '冒泡法对数组排序 For i = 1 To 6 For ii = i To 6 If num(1, i) > num(1, ii) Then res = num(1, i) num(1, i) = num(1, ii) num(1, ii) = res res1 = num(0, i) num(0, i) = num(0, ii) num(0, ii) = res1 End If Next ii Next i n = Cells(4, 3) For i = 1 To n Cells(i + 11, 2) = num(0, i) Cells(i + 11, 3) = num(1, i) Next i End Sub
|