技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 22799
|
3#
發(fā)表于 2016-6-1 09:11:27
|
只看該作者
寫了一個自定義函數(shù)。不過沒有進(jìn)行錯誤處理
- Function GetData(ByVal rngBegin As Range, ByVal rngEnd As Range)
- Dim dblBegin As Double, dblEnd As Double
- Dim i As Double, s As String
-
- dblBegin = CDbl(rngBegin.Value)
- dblEnd = CDbl(rngEnd.Value)
- For i = dblEnd - 1 To dblBegin + 1 Step -1
- s = i & "," & s
- Next i
- GetData = Left(s, Len(s) - 1)
- End Function
復(fù)制代碼
所以最好加上ISError進(jìn)行錯誤處理,例如:
=IF(ISERROR(GetData(B6,B7)),"",GetData(B6,B7))
|
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒有帳號?注冊
x
|