Results 1 to 3 of 3

Thread: HOW TO: Excel: Detect a return of "Nothing" from a function ???

Threaded View

  1. Apr 6th, 2005, 03:04 PM #1
    Webtest
    Webtest is offline

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved HOW TO: Excel: Detect a return of "Nothing" from a function ???

    Esteemed Forum Participants and Lurkers:
    ===============================

    EXCEL VBA

    I have a function that returns a calculated range from a sheet or "Nothing" if the sheet is blank.

    How can I detect that "Nothing" in my code? One of the Help Heap screens in my old Excel '97 says "you can detect Nothing with the IsNothing function", but of course, the IsNothing function doesn't exist, and that comment is omitted in the new XP version of Excel. I have been beating my head against a brick wall for a couple of hours now trying to find a simple solution to this.

    Thank you for any comments, suggestions, and assistance in this inquiry.
    Last edited by Webtest; Apr 6th, 2005 at 03:21 PM. Reason: [RESOLVED]
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width