|
fcdd 发表于 2013-12-28 11:38
大虾可以再请你修改一下
字母不分大小写···
看看这个
- Private Sub CommandButton1_Click()
- Dim arr, brr() As String, d
- Dim i&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets(2).Range("a2").CurrentRegion.Value
- For i = 1 To UBound(arr)
- d(arr(i, 2)) = arr(i, 1)
- Next
- With Sheets(1)
- arr = .Range("K1", .Cells(Rows.Count, "k").End(3)).Value
- ReDim brr(1 To UBound(arr), 1 To 1) As String
- For i = 1 To UBound(arr)
- brr(i, 1) = d(Left(arr(i, 1), 1))
- Next
- .Range("b1").Resize(Rows.Count).ClearContents
- .Range("b1").Resize(UBound(arr)) = brr
- End With
- End Sub
复制代码 |
|