VBA## on error go to多次跳轉問題## 求教
代碼如下：
Function Owner(CPN as string，WholePN as range，Versionless as range) as string
Err.Clear
On Error GoTo Line1
Owner = WorksheetFunction.Vlookup(CPN, WholePN, 3, 0)
GoTo FinalOwner
Line1：
Err.Clear
On Error GoTo Line2
Owner = WorksheetFunction.Vlookup(Left(CPN,Len(CPN) - 3), Versionless as range, 2, 0)
GoTo FinalOwner
Line2:
Err.Clear
On Error GoTo Line3
Owner = WorksheetFunction.Vlookup(Left(CPN,Len(CPN) - 1), WholePN, 3, 0)
GoTo FinalOwner
Line3:
Err.Clear
On Error GoTo Line4
Owner = “NA”
FinalOwner:
End Function
測驗發現第5行和第11行的結果是可以出來，但是后面兩種情況怎么都是"#VALUE!"
按道理不管CPN是個啥，結果最差也是"NA"才對呀，為啥出來"#VALUE!"?求大神指教。謝謝!
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/177206.html
標籤：VBA
上一篇：vb重裝后不認圖示