+ Reply to Thread
Results 1 to 3 of 3

Check if any cell in range is blank

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Check if any cell in range is blank

    Hello

    I have this range
    Please Login or Register  to view this content.
    i want vba code to check if any cell in this range is blank, then show msgbox

    Thanks
    Last edited by alansidman; 08-15-2019 at 03:30 PM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Check if any cell in range is blank

    Try something like...
    Please Login or Register  to view this content.
    Note that for referencing Table column, you don't need Sheet reference, as table name must be unique within workbook.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Check if any cell in range is blank

    Here is some aircode (untested)

    Please Login or Register  to view this content.
    Note: Please use Code tags when posting any type of code. I have added for you today.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to check no. of blank in each row in cell range
    By Rocky2013 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2018, 01:08 PM
  2. [SOLVED] i want formula check cell if cell is blank go to next cell and check value and give grades
    By pksrikanth85 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-19-2017, 12:42 PM
  3. [SOLVED] Check same cell on range of worksheets and if not blank, copy into a list on another sheet
    By eddiecruz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 05:14 PM
  4. [SOLVED] How to check if two cells in a range of four are not blank?
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2013, 08:06 AM
  5. Replies: 2
    Last Post: 02-24-2012, 06:23 AM
  6. check if a range is blank relative to current cell in vba
    By sark666 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2009, 10:37 PM
  7. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM

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