|
发表于 2012-9-21 15:59
|
显示全部楼层
本楼为最佳答案
本帖最后由 hrpotter 于 2012-9-21 16:04 编辑
- Sub test()
- Dim arr, brr, i As Long, j As Long
- arr = Sheets("区号").Range("a1").CurrentRegion
- With Sheets(1)
- brr = .Range("a1").CurrentRegion
- For i = 2 To UBound(brr)
- If brr(i, 2) = "" Then
- For j = 2 To UBound(arr)
- If InStr(brr(i, 1), arr(j, 1)) = 1 Then
- brr(i, 2) = arr(j, 2)
- brr(i, 3) = arr(j, 3)
- Exit For
- End If
- Next
- End If
- Next
- .Range("a1").Resize(UBound(brr), UBound(brr, 2)).ClearContents
- .Range("a1").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |
|