|
- Function PLZH(最小值, 最大值, 指定位数)
- nmin = 最小值
- nmax = 最大值
- n = nmax - nmin + 1
- m = 指定位数
- arr = ArrPC(n, m, 4, nmin, 1)
- If Application.Version = "11.0" Then '2003版本
- N3 = Application.Caller.Rows.Count
- Else
- gsh = Application.ThisCell.Formula
- Do While gsh = Application.ThisCell.Offset(N3, 0).Formula
- If Application.ThisCell.Offset(N3, 0).Row = Rows.Count Then Exit Do
- N3 = N3 + 1
- Loop
- End If
- ReDim brr(1 To N3, 1 To 1)
- If UBound(arr) > N3 Then k = N3 Else k = UBound(arr)
- For i = 1 To k
- For j = 1 To UBound(arr, 2)
- brr(i, 1) = brr(i, 1) & arr(i, j)
- Next j, i
- For ii = i To N3
- brr(ii, 1) = ""
- Next
- PLZH = brr
- End Function
复制代码 |
评分
-
1
查看全部评分
-
|