|
发表于 2012-11-8 13:57
|
显示全部楼层
本楼为最佳答案
本帖最后由 hwc2ycy 于 2012-11-8 14:03 编辑
- Sub 合并内容()
- Dim shtS
- Dim colh$, colj$
- Dim i&
- Application.ScreenUpdating = False
- Union(Range("h3:h6"), Range("j3:j6")).ClearContents
- For Each shtS In Worksheets
- If shtS.Name Like "表*" Then
- For i = 3 To 6
- colh = Cells(i, "h")
- colj = Cells(i, "j")
- If Len(colh) Then colh = colh & Chr(10)
- If Len(colj) Then colj = colj & Chr(10)
- Cells(i, "h") = colh & shtS.Cells(i, "h")
- Cells(i, "j") = colj & shtS.Cells(i, "j")
- Next
- End If
- Next
- Union(Range("h3:h6"), Range("j3:j6")).EntireColumn.AutoFit
- Application.ScreenUpdating = True
- End Sub
复制代码 多加了2句判断,空白行没有了。
刚没加防刷屏的,现在补上了。 |
|