|
发表于 2014-1-13 22:39
|
显示全部楼层
本楼为最佳答案
- Sub 自动在勘探总表中备注()
- Dim m, m1, m2, x, k, wh, wb
- Set wh = ThisWorkbook.Sheets("岩样单")
- Set wb = Workbooks.Open(ThisWorkbook.Path & "/4-衢宁初测2测段钻孔信息一览表01.03戴核.xlsx")
- wh.Activate
- For m = 7 To wh.Range("o65536").End(xlUp).Row
- If Range("o" & m) = "√" Then
- If Not [c:c].Find("Jz-*", After:=Range("c" & m), searchdirection:=xlPrevious) Is Nothing Then
- m1 = [c:c].Find("Jz-*", After:=Range("c" & m), searchdirection:=xlPrevious).Row
- If Not wb.Sheets(1).[b:b].Find(Range("c" & m1)) Is Nothing Then
- m2 = wb.Sheets(1).[b:b].Find(Range("c" & m1)).Row
- wb.Sheets(1).Range("al" & m2) = "薄片"
- k = k + 1
- End If
- End If
- End If
- 'm2 = wb.Sheets(1).[b:b].Find(Range("c" & m1)).Row
- 'wb.Sheets(1).Range("al" & m2) = "薄片"
- 'k = k + 1
- 'End If
- Next m
- MsgBox "共有" & k & "个数据"
- End Sub
复制代码 |
|