Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Evaluate for empty cell

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm getting a type mismatch error when I check for an empty cell in a row
    which has a date in it. The following attempts have produced the type
    mismatch error:

    do while .Range(strDateCell).Value = vbNull
    do while IsEmpty(.Range(strDateCell).Value) = false
    do while .Range(strDateCell).Value < format("01/01/1980","mm/dd/yyyy")

    I'm SURE that this is so unbelievably simple, I just can't think of it right
    now.

    TIA
    Ron


    [ This Message was edited by: rlevau on 2002-04-09 12:47 ]

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do While Range(strDateCell).Value <> ""

    This will do while the value is not empty. Is that what you want?
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you so very much!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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