+ Reply to Thread
Results 1 to 3 of 3

Difference between "empty" and zero?

  1. #1
    Registered User
    Join Date
    03-02-2006
    Posts
    17

    Difference between "empty" and zero?

    I have a loop which runs through a range and stops when it hits the bottom of the range:

    Do until activecell.value = empty
    activecell.offset(0,1).activate
    loop

    However, the range has some zeroes in it, and the macro stops when it hits a zero. I don't want this to happen, a zero is a valid entry in this range. I just want it to detect when the cell has nothing in it.

    This issue comes up a lot in my work, so can anyone suggest how to deal with it? That is, how can I differentiate between an empty cell and a cell with a zero in it?

  2. #2
    Registered User
    Join Date
    09-20-2006
    Location
    Poland
    Posts
    46
    Quote Originally Posted by timspier
    This issue comes up a lot in my work, so can anyone suggest how to deal with it? That is, how can I differentiate between an empty cell and a cell with a zero in it?
    Try:

    Please Login or Register  to view this content.
    MS Excel Games Library and much more:
    http://www.dzikosoft.com/gmexcel

  3. #3
    Registered User
    Join Date
    03-02-2006
    Posts
    17

    Cool!

    Great, thanks a ton!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1