摘要: Sub WorkbooksConsolidate() Rem 设置求和区域为 sheet名称/单元格区域;sheet名称/单元格区域 Const Setting As String = "Sheet1/A1:G6;Sheet1/A8:E8;Sheet1/F8:G8;Sheet2/A1:G3;Sheet2/A5:G5" Const FOLDER_NAME As String... 阅读全文
posted @ 2018-08-31 11:03 wangway 阅读(221) 评论(0) 推荐(0) 编辑
摘要: Sub WorkSheetsConsolidate() Rem 设置求和区域为 单元格区域;单元格区域 Const Setting As String = "A1;B2:C4" Dim StartTime As Variant Dim UsedTime As Variant StartTime = VBA.Timer AppSetting... 阅读全文
posted @ 2018-08-31 11:00 wangway 阅读(255) 评论(0) 推荐(0) 编辑