本帖最后由 fangniuji 于 2012-11-29 09:59 编辑
帮忙一下在这边,写个查找Vba,Ah列编号对应AI列孔型,再看整理介绍
B2默认为编号T01,B3默认为编号T02,以此类推,故E2等于AA,E11=BB,E21=CC
- Sub 扫描()
- Dim irow&
- Dim arr, i&
- irow = Range("ah" & Rows.Count).End(xlUp).Row()
- If irow = 1 Then Exit Sub
- With Worksheets("扫孔")
- arr = .Range("ah1").CurrentRegion
- .Range("ah1").CurrentRegion.ClearContents
- End With
- On Error Resume Next
- With Worksheets("整理")
- If Err.Number <> 0 Then
- MsgBox "工作表读取错误"
- Err.Clear
- Exit Sub
- End If
- For i = LBound(arr) + 1 To UBound(arr)
-
- irow = .Range("a:a").Find(Trim(arr(i, 1)), LookIn:=xlValues, lookat:=xlWhole).Row()
- If Err.Number <> 0 Then
- MsgBox arr(i, 1) & "无匹配项"
- Err.Clear
- Else
- arr(i, 2) = .Cells(irow, "e").Value
- End If
- Next
- End With
- With Worksheets("扫孔")
- .Range("ah1").CurrentRegion.ClearContents
- .Range("ah1").Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码其实用VLOOKUP就能解决啊。
|