Results 1 to 12 of 12

Need help to pop up the mesgbox on null cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    Unhappy Need help to pop up the mesgbox on null cells

    Hi guys,

    I need your help to show up the mesgbox on null blanks. Like for example i have 10 rows and 10 columns and a button which checks for validation now whenever i press that button it will check all the 10 rows and 10 columns that there would be no blank cell in between if it found any cell blank, it will pop up the error message.

    I am thinking in 2 ways:

    1) As if one column is filled so we can check the whole bunch of columns next to each other till the end.
    2) we can check for the whole filled sheet that either if they are empty of not.

    I am new in VBA, Kindly help me in this scenorio.

    Thanks in Advance i attached the file already so you guys can have a look at it.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting the non-null cells in a range with noncontinguous cells in a round-robin
    By StudentTeacher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 07:28 AM
  2. Replies: 1
    Last Post: 11-13-2011, 04:03 AM
  3. Not Null Cells
    By cxi in forum Excel General
    Replies: 1
    Last Post: 06-01-2011, 08:14 AM
  4. Code to replace null and not null strings
    By tigertim71 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2008, 05:07 PM
  5. Advanced filter - display null or non-null
    By Duddles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2008, 11:17 PM

Tags for this Thread

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