Here’s a little worksheet function that doesn’t get the credit it deserves. ISNONTEXT() works just like ISNUMBER() except that it returns TRUE for blank cells.
Here’s a little worksheet function that doesn’t get the credit it deserves. ISNONTEXT() works just like ISNUMBER() except that it returns TRUE for blank cells.
Posting code? Use <pre> tags for VBA and <code> tags for inline.