+ Reply to Thread
Results 1 to 10 of 10

Code to exit and not call module if certain ranges are blank

  1. 10-07-2014, 04:27 PM #1
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Code to exit and not call module if certain ranges are blank

    I have ranges on a sheet
    B10:b19
    B21:B30
    B32:B39
    B41:B48
    B50:B57
    B59:B66

    If those Ranges are totally blank then I want it exit and not call module

    then if one of the ranges has a cell populated then it calls the module.

    Code i Have that calls the module now is

    Please Login or Register  to view this content.
    what would I add to make it do what I would like.
    Reply With QuoteRegister To Reply
  2. 10-07-2014, 04:38 PM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Code to exit and not call module if certain ranges are blank 

    Please Login or Register  to view this content.
    Last edited by mikeTRON; 10-07-2014 at 04:46 PM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
    Reply With QuoteRegister To Reply
  3. 10-07-2014, 04:53 PM #3
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Re: Code to exit and not call module if certain ranges are blank

    Sorry, one more addition could it clear contents out of the range on a tab "Job Ticket" the range is A10:N67 first then exit


    I am making changes as it works so I can see what need to be done next.
    Reply With QuoteRegister To Reply
  4. 10-07-2014, 05:08 PM #4
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Code to exit and not call module if certain ranges are blank 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 10-07-2014, 05:08 PM #5
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Re: Code to exit and not call module if certain ranges are blank

    I just noticed that I was not clear on my explanation.

    The Range that it is checking is on another sheet Named (Daily Chgs) that is where the range is located that it is checking for blanks and the range to clear contents are on the sheet Named "Job Ticket" Range A10:N67
    Reply With QuoteRegister To Reply
  6. 10-07-2014, 05:09 PM #6
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Code to exit and not call module if certain ranges are blank

    You are correct. You are unclear. LOL

    You have lost me.
    Reply With QuoteRegister To Reply
  7. 10-07-2014, 05:23 PM #7
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Re: Code to exit and not call module if certain ranges are blank

    Let me start over... I tried to convert your code ..Not Successful 

    Please Login or Register  to view this content.
    The range to check for the blanks is on the sheet "Daily Chgs"
    The sheet that I want the Contents cleared is "Job Ticket" Range A10:N67
    Sheet PW is Financial3



    when they activate the Sheet "Job Ticket" I want it to check and see if the ranges on the sheet "Daily Chgs" are Blank
    "B10:B19, B21:B30, B32:B39, B41:B48, B50:B57, B59:B66, B10:B19"

    If they are blank then I want it to clear the contents on the "Job Ticket" Range (A10:N67) and then exit sub

    If the checked range on the "Daily Chgs" tab is found not be blank then I want it to call Module "PopulatesJobTicket.NewDateRange"

    I hope this is better explanation
    Reply With QuoteRegister To Reply
  8. 10-07-2014, 06:12 PM #8
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Code to exit and not call module if certain ranges are blank

    I would not use ActiveSheet, I would call it out explicitly as noted in the code below.

    I also added a ton of comments so you can understand what is going on.

    Please Login or Register  to view this content.

    You can make this code MUCH smaller, or less text, but when new I prefer to have more visibility into what exactly is going on.

    If you have any questions, let me know.

    Also check out this website so you can learn how to properly step through code and determine how to correct things.
    http://www.cpearson.com/excel/DebuggingVBA.aspx
    Last edited by mikeTRON; 10-07-2014 at 06:18 PM.
    Reply With QuoteRegister To Reply
  9. 10-07-2014, 07:16 PM #9
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Re: Code to exit and not call module if certain ranges are blank

    I will try it out when home thanks for the help
    Reply With QuoteRegister To Reply
  10. 10-07-2014, 09:00 PM #10
    bdouglas1011
    bdouglas1011 is offline
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Re: Code to exit and not call module if certain ranges are blank

    I seems to be working good thank you...I will put it to the test tomorrow when i put the entire sheet through a trial run.

    Again thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can I call a Module or a sub procedure and run it automatically in current module?
    By qzqzjcjp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2014, 11:48 AM
  2. [SOLVED] VBA code: A Sub() module to CALL another Sub ()
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2013, 08:48 AM
  3. Call combobox_change function on exit.
    By hubert_ii in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-23-2009, 09:05 AM
  4. how to access Sheet module, normal module, Worbook module to type code
    By alibaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2009, 07:51 AM
  5. Call Code in One Module Into Another
    By SEOT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2008, 11:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1