I tried to use the ISNumber() function within VBA but it is not usable.

2 Questions:
1. How can I know which functions can be used in VBA and which can not?
2. How do I determine if the value of a cell is a number?

I don't want to enter a formula in a cell and then test the value of that
cell, I just want to do it in the code if possible. Thanks...