|
发表于 2015-12-3 20:59
|
显示全部楼层
本楼为最佳答案
Sub Click()
Dim A, B, C, i, j
A = Range("a4:a" & Range("a65536").End(3).Row)
B = Range("d1").CurrentRegion
ReDim C(Application.Min(B) To Application.Max(B))
For j = 1 To UBound(B, 2)
C(B(1, j)) = B(2, j)
Next j
For i = 1 To UBound(A)
A(i, 1) = C(A(i, 1))
Next i
[b4].Resize(UBound(A)) = A
End Sub
Book18.rar
(66.42 KB, 下载次数: 19)
|
|