Sub Click()
Dim A, B, i, j
A = [h36:an36] '是手动指定的?
B = Range("a38").CurrentRegion '可能要改,需根据A38周围数据,来确定如何赋值。
For i = 1 To UBound(B)
For j = 1 To UBound(B, 2)
B(i, j) = A(1, B(i, j))
Next j
Next i
[H38].Resize(UBound(B), UBound(B, 2)) = B
End Sub Book当前遗露2.rar(23.03 KB, 下载次数: 5)