VBA实现按合并单元格拆分Excel工作表

VBA split Excel worksheet by merging cells

在Excel应用中,部门信息常见的格式设置,一种是占据一列,另一种格式为合并单元格,占据一行,文章讨论的是后一种,通过合并单元格的判定,确定要包含的数据范围,然后复制到以合并单元格提取的内容作为新建工作簿命名的文件中去。

In Excel application, one of the common format settings of departmental information is to occupy one column. The other format is a merged cell, which occupies a row. This paper discusses the latter one, and determines the cells to be included in the judgment by merging the cells data range, and then copy the contents extracted as a merged cell into the file named as a new workbook.