vba - Excel UDF to count errors -


I was trying to write an UDF in Excel VBA that counts errors (#nA !, #REF! ...). I tried to not do Excel formulas successfully in the VBA language cude. Does anyone know the solution?

Thanks

How about

  Public Function CountErr (Cells As Limit) As long as the cell range for cells in each cell as the application. Worksheet Function. Ice Error (Cell) Then Countter = CountErr + 1 Next End Function  

Comments