怎么把EXCEL的一个工作簿中多个工作表的内容合并到一个工作表?? 一个工作簿中有38个工作表,怎么把这38个工作表的内容合并到一个新的工作表???怎么用宏啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Private Sub CommandButton1_Click() Dim tmpSht, srcSht As Worksheet Dim i, cpyStartRow As Integer cpyStartRow = 0 For i = 1 To Application.ActiveWorkbook.Worksheets.Count If i > 1 Then Set tmpSht = ActiveWorkbook.Worksheets(i) '' tmpSht.UsedRange.Select tmpSht.UsedRange.Copy srcSht.Cells(cpyStartRow, 1).Value = "----------------" & tmpSht.Name & "----------------" srcSht.Cells(cpyStartRow + 1, 1).Select srcSht.Paste cpyStartRow = cpyStartRow + tmpSht.UsedRange.Rows.Count + 1 Else Set srcSht = ActiveWorkbook.Worksheets(i) cpyStartRow = srcSht.UsedRange.Row + srcSht.UsedRange.Rows.Count + 1 End If Next i End Sub vb6, 要怎么让原来的form 知道这菜单仍然开着,或已自行关闭了? 關于CRYSTYLE的問題` 散分! 优化查询 远程数据访问测试!如果测试成功!需要源码的留下Email 这些代码有什么正经用途?? 菜鸟问题 dll问题。很简单。 ★★★★★★寻XP样式的Combobox★★★★★★ 帮帮我~~~~~~~20分啊~~~~~~~~~~~~ 用户定义类型未定义 错误 怎么办? VB背景问题求助 绝对菜鸟
Private Sub CommandButton1_Click()
Dim tmpSht, srcSht As Worksheet
Dim i, cpyStartRow As Integer
cpyStartRow = 0
For i = 1 To Application.ActiveWorkbook.Worksheets.Count
If i > 1 Then
Set tmpSht = ActiveWorkbook.Worksheets(i)
'' tmpSht.UsedRange.Select
tmpSht.UsedRange.Copy
srcSht.Cells(cpyStartRow, 1).Value = "----------------" & tmpSht.Name & "----------------"
srcSht.Cells(cpyStartRow + 1, 1).Select
srcSht.Paste
cpyStartRow = cpyStartRow + tmpSht.UsedRange.Rows.Count + 1
Else
Set srcSht = ActiveWorkbook.Worksheets(i)
cpyStartRow = srcSht.UsedRange.Row + srcSht.UsedRange.Rows.Count + 1
End If
Next i
End Sub