|
楼主 |
发表于 2019-9-25 10:19
|
显示全部楼层
Dim arr, brr
Sub 打开文件的()
m = Sheet2.Range("A" & Rows.Count).End(3).Row
arr = Sheet2.Range("A2:a" & m)
brr = Sheet2.Range("A2:f" & m)
End Sub
Private Sub Worksheet_Activate()
Call Sheet1.打开文件的
End Sub
Sub 第一条()
[b2] = brr(1, 1)
[d2] = brr(1, 2)
[f2] = brr(1, 3)
[b3] = brr(1, 4)
[b4] = brr(1, 5)
[b5] = brr(1, 6)
End Sub
Sub 最后一条()
s = UBound(arr)
[b2] = brr(s, 1)
[d2] = brr(s, 2)
[f2] = brr(s, 3)
[b3] = brr(s, 4)
[b4] = brr(s, 5)
[b5] = brr(s, 6)
End Sub
Sub 下一条()
b2 = [b2]
w = Application.Match(b2, arr, 0)
s = UBound(arr)
If w = s Then Exit Sub
[d2] = brr(w + 1, 2)
[f2] = brr(w + 1, 3)
[b3] = brr(w + 1, 4)
[b4] = brr(w + 1, 5)
[b5] = brr(w + 1, 6)
Range("B2") = brr(w + 1, 1)
End Sub
Sub 上一条()
b2 = [b2]
w = Application.Match(b2, arr, 0)
If w = 1 Then Exit Sub
[d2] = brr(w - 1, 2)
[f2] = brr(w - 1, 3)
[b3] = brr(w - 1, 4)
[b4] = brr(w - 1, 5)
[b5] = brr(w - 1, 6)
Range("B2") = brr(w - 1, 1)
End Sub
|
|