分表的表头有合并单元格项,保留分表格式使用VBA合并多个分表,但是汇总表中之汇总了表头格式,表头内容却没有汇总进去,是什么原因呢?
是代码写的不对吗?以下是代码
Sub CollectDataFromShtFormat()
Dim sht As Worksheet, rng As Range, k As Long, nTitleCount As Long
On Error Resume Next
nTitleCount = Val(InputBox("请输入标题的行数", "提醒", 1))
If nTitleCount < 0 Then Ms...