For instance, using the name CDE567 is not allowed. You cant use space in your Excel functions. That said, you can use an underscore like average_count in your function.

To demonstrate that VBA macros are not always needed, he wrote a 3D game engine using nothing but Excel formulae. He did have to resort to VBA to get user input and in a very few cases to improve ...