Excel UDF用于计数错误

Question

我试图用Excel编写一个UDF来计算错误(#NA!，#REF！.)。我试着把Excel公式翻译成VBA语言芽没有成功。有人知道解决办法吗？

谢谢

Answer 1

怎么样

Public Function CountErr(cells As range) As Long
   Dim cell As range
   For Each cell In cells
      If Application.WorksheetFunction.IsError(cell) Then CountErr = CountErr + 1
   Next
End Function