|
本帖最后由 byhdch 于 2014-5-25 00:02 编辑
- Private Sub CommandButton1_Click()
- Dim i As Long, j&
- Dim arr
- Application.ScreenUpdating = False '关闭屏幕刷新
- For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
- If Cells(i, "D") <> "" Then
- arr = Range(Cells(i, "N"), Cells(i, "Y"))
- With Sheets(Cells(i, 1).Value)
- j = .Range("C:C").Find(Cells(i, "D")).Row
- .Cells(j, "M").Resize(, UBound(arr, 2)) = arr
- End With
- End If
- Next i
- Application.ScreenUpdating = True '打开屏幕刷新
- End Sub
复制代码
9.rar
(53.41 KB, 下载次数: 15)
|
|