|
比较蛋疼,但是可以实现你的要求- Function FunCrank(ByVal rng1 As Range, Optional ByVal rng2 As Range, Optional ByVal rng3 As Range, _
- Optional ByVal rng4 As Range, Optional ByVal rng5 As Range, Optional ByVal rng6 As Range)
- '比较蛋疼,用参数数组好像不可以,没弄出来,区域不够自己再加吧
- Dim totalRange As Range, rng As Range
-
- Set totalRange = rng1
- Call UnionRange(totalRange, rng2) '判断,合并区域
- Call UnionRange(totalRange, rng3)
- Call UnionRange(totalRange, rng4)
- Call UnionRange(totalRange, rng5)
- Call UnionRange(totalRange, rng6)
- '--------------------------------------------------------------
- For Each rng In totalRange
- If rng.HasFormula Then FunCrank = FunCrank + 1 '判断单元格是否含有公式
- Next
- End Function
- Sub UnionRange(ByRef MainRng As Range, ByVal rng As Range) '自定义方法,主参数使用传地址,有条件合并区域
- If Not rng Is Nothing Then Set MainRng = Union(MainRng, rng) '
- End Sub
复制代码
|
评分
-
查看全部评分
|