|
- Sub 合同总额()
- Dim arr, i, brr, j
- On Error Resume Next
- Call 取消组合 '加取消组合和组合,应急满足运行宏要求
- arr = [o3:s34] '数据源,O是拼音,后面是数据源
- brr = [l3:m8] '颜色区域
- For i = 1 To UBound(brr)
- brr(i, 1) = Range("l" & i + 2).Interior.Color '把颜色值给brr(i,1)
- Next
- For j = 1 To UBound(arr) '通过改变arr(j,N)中的n换数据源,range("m3:m8")换数据范围,自己试试
- ActiveSheet.Shapes(arr(j, 1)).Fill.ForeColor.RGB = brr(Application.Match(Application.Lookup(arr(j, 4), Range("m3:m8")), [m3:m8], 0), 1)
- Next
- Call 组合
- End Sub
- Sub 组合() '通过录制宏写代码
- ActiveSheet.Shapes.Range(Array("hainan", _
- "shanghai", "henan", "taiwan", "guangdong", "guangxi", "fujian", "jiangxi", _
- "hunan", "guizhou", "zhejiang", "anhui", "jiangsu", "hubei", "shanxi3", _
- "shanxi1", "shandong", "tianjin", "beijing", "ninxia", "xizang", "yunnan", _
- "qinghai", "sichuan", "gansu", "hebei", "neimenggu", "liaoning", "jilin", _
- "heilongjiang", "xinjiang", "chongqing")).Select
- ActiveWindow.SmallScroll Down:=3
- Selection.ShapeRange.Group.Select
- Selection.Name = "zuhe" '给他取名
- End Sub
- Sub 取消组合()
- ActiveSheet.Shapes("zuhe").Select
- Selection.ShapeRange.Ungroup.Select
- End Sub
复制代码 |
评分
-
查看全部评分
|