Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Testing for a Blank Cell

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    North Wales Coast, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Evening All,
    This is just a quick question, with hopefully a quick answer.
    I am looking to 'test' to see if a cell is blank within a macro.
    I would be grateful if someone could please point me in the right direction.
    Cheers
    S

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try this

    sub checkifempty
    If Range("a1").Value = "" Then MsgBox "sorry 'ol chap. the cell is empty"
    Exit Sub

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    North Wales Coast, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just a quick thank you to you both for responding so promptly.
    I will be 'Excel'ling in the morning - testing for Blank Cells!
    Cheers
    S

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
  •