|
本帖最后由 无为123456 于 2015-12-24 22:09 编辑
如何使固定列号改为按第四行的最后一个空格的列号赋值?
.[f4].Resize(UBound(ar)) = ar
请版主或大家费心帮忙,谢谢!!!
Private Sub CommandButton1_Click()
Dim d As Object, i%, myname$, ar
Set d = CreateObject("scripting.dictionary")
myname = ThisWorkbook.Path & "\工资.xls"
Application.ScreenUpdating = False
With GetObject(myname)
With .Sheets("工资")
ar = .Range("a4", .[r65536].End(3))
End With
.Close
End With
For i = 1 To UBound(ar)
d(ar(i, 4)) = ar(i, 18)
Next
With Sheets("员工名册")
ar = .Range("c4", .[c65536].End(3))
For i = 1 To UBound(ar)
ar(i, 1) = d(ar(i, 1))
Next
.[f4].Resize(UBound(ar)) = ar
End With
Application.ScreenUpdating = True
End Sub
|
|