Just for completeness, "Is Nothing" only works on objects, which is why you were getting the Object Required error message.