|
- Function GetName(ByVal rngs As range, Optional ByVal val As Long = 2000, Optional ByVal joint As String = " ") As String
- 'rngs为姓名所在区域;val为需要比较的数,默认2000;joint为连接符,默认为空格
- Dim arr(), rng As range, n As Long
-
- Application.Volatile '易失性函数
- For Each rng In rngs
- If rng.Offset(, 1) > val Then '判断
- n = n + 1
- ReDim Preserve arr(1 To n) '动态数组,保存已有数据
- arr(n) = rng.Value
- End If
- Next
- GetName = join(arr, joint) '输出数据,将数组中元素连接,joint为连接符
- End Function
复制代码
|
评分
-
查看全部评分
|