excelVBA复制粘贴可见单元格智能合并拆分单元格

所属分类:Windows编程
开发工具:VBA
文件大小:1KB
下载次数:6
上传日期:2017-12-19 01:36:17
上 传 者zcbee
说明:  excel表中个别行或列隐藏或进行数据筛选后,复制粘贴不能实现可见单元格粘贴,本程序可实现此功能,运行此代码按提示操作即可。 excel表中,有合并的单元拆分后,只有第一个单元格记录合并前数据,智能合并拆分单元格程序则可以实现拆分后所有单元格数据均为拆分前的数据。本程序还可实现同一区域内所有数据相同且相邻的数据一次性分别合并居中。
(After hiding or filtering data in Excel table, copy and paste can not realize visible cell paste. This program can achieve this function, run this code according to prompt operation. In the excel table, after merging unit splits, only the first cell records the data before merging. After merging and splitting the cell program intelligently, all the cell data can be divided into the data before splitting. This program can also achieve the same and adjacent data in the same area.)

文件列表:
excelVBA 复制粘贴可见单元格功能.txt (4285, 2017-12-19)

近期下载者

相关文件


收藏者