|
把B列数据源%下,两把刀序坐标提取放C,D列如C,D列,M30不是坐标不提取,谢谢。
- Private Sub CommandButton1_Click()
- Dim i&, j%, arr, arr1(1 To 100, 1 To 100), n&, l&, m%
- n = Application.Match("%", Range("b1:b" & Range("b65536").End(3).Row), 0)
- arr = Range("b" & n + 1 & ":b" & Range("b65536").End(3).Row)
- m = 0: l = 1
- For i = 1 To UBound(arr)
- If Left(arr(i, 1), 1) = "T" Then m = m + 1: l = 1: arr1(l, m) = arr(i, 1)
- If Left(arr(i, 1), 1) = "X" Then l = l + 1: arr1(l, m) = arr(i, 1)
- Next i
- [c1].Resize(UBound(arr1), UBound(arr1, 2)) = arr1
- End Sub
复制代码
|
|