I have written what I consider to be a very simple function to test a cell for data validation but clearly I am missing something. The function returns true when it should return false and, after being run once, I receive a Function not defined error.
I have rewritten it many different ways; here is the current version:
The function is stored in my PERSONAL.xlsb workbook and I am testing the function through the Immediate window of the VBE. I have tried referring to ActiveCell as well as a range with the same results. It works once but doesn't necessarily return the correct value and then I receive the "Sub or Function not defined" error on subsequent attempts.Please Login or Register to view this content.
No clue why this isn't working.
Bookmarks