vba 1004错误
vba 1004错误
日期:2022-04-02 02:14:00 人气:1
Dim r, u As Integer
u = UsedRange.Columns.Count
If UsedRange.Columns.Count <> Sheets(2).UsedRange.Columns.Column Then
For r = 2 To 6
Range(Cells(2, 2), Cells(2, u)).Copy Sheets(r).Range(
u = UsedRange.Columns.Count
If UsedRange.Columns.Count <> Sheets(2).UsedRange.Columns.Column Then
For r = 2 To 6
Range(Cells(2, 2), Cells(2, u)).Copy Sheets(r).Range(