+ Reply to Thread
Results 1 to 4 of 4

determine if a cell is empty

  1. #1
    Registered User
    Join Date
    05-26-2007
    Posts
    53

    Unhappy determine if a cell is empty

    I need something which I think is very simple, but because I'm new to VB, I'm missing.

    1. I need to determine if a specified cell is empty or has a value;
    2. I need to determine if the value in a specified cell is type date

    Can you, please help?

  2. #2
    Forum Contributor
    Join Date
    11-23-2005
    Location
    Perth, Australia
    Posts
    218

    determine if a cell is empty

    So Many different ways!

    Here is an example of one way :

    This first checks to see if Cell A1 is empty and if it is not empty it checks to see if it is in Date Format:

    Please Login or Register  to view this content.
    Hope this helps, let me know how you go!

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Use IsEmpty to check for a completely empty Cell

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    05-26-2007
    Posts
    53

    Smile

    Thanks everybody. I addapted both ideas to my macro and it worked.

+ 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