+ Reply to Thread
Results 1 to 2 of 2

Call a macro if cells are empty

  1. #1
    Registered User
    Join Date
    04-07-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    49

    Call a macro if cells are empty

    I'm trying to write a macro that will check to make sure columns B, E, F, and G are empty before calling the next macro. If not then it pops up a message box to prompts the user to fix it. The problem I'm having is that it always goes to the msgbox even if the columns are empty. My code is below. Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Call a macro if cells are empty

    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ 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] Call a specific macro by selecting different cells
    By ska87RA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2013, 09:14 AM
  2. Call Macro Based on a non empty Cell Value.
    By Purdydog in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2013, 03:34 PM
  3. MACRO to empty a range of cells based on whether specified cell is empty
    By TBJV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 10:35 PM
  4. Stopping a macro on empty cells
    By dymention2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 08:11 AM
  5. macro to colour empty cells (cells not recognized as empty)
    By Gerben in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2005, 11:05 AM

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