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
Post a Comment