Problem with IsNumeric in Excel 2013 VBA

Hi all. I am having trouble using the IsNumeric function in some VBA code in Excel 2013. Here is a simple version of the code:

Please Login or Register  to view this content.

When I run this code, Excel gives me an error box that says "Compile error: Wrong number of arguments or invalid property assignment". It doesn't matter what the selected cell contains. When I step through the code, the error occurs at the IsNumeric line. I have Googled my heart out but can't figure this one out. If there is a better simple way to determine whether a given cell contains a number, I'm all ears. Thanks.

Originally Posted by alansidman

In the VBE, click on Tools, and references. See if any are marked with Missing.

Thanks for the response Alan. When I checked VBE->Tools->References, a dialog box opens titled "References - VBAProject". Under "Available References" there are 100 or more items, most of them unchecked. The only items that are checked are Visual Basic for Applications, Microsoft Excel 15.0 Object Library, OLE Automation and Microsoft Office 15.0 Object Library. Nothing seems to be marked as Missing. Should I be looking for anything in particular here?

Originally Posted by Izandol

I think you have other routine/module/variable named IsNumeric.

EUREKA!!! You nailed it. Buried in some long forgotten module of test VBA code, I had a macro called "isnumeric". I changed the name, and everything worked as expected.

Thank you Izandol and alansidman for your help!

Done! Thanks...