+ Reply to Thread
Results 1 to 6 of 6

Ignore Blank Cells in Looping Range

  1. #1
    Registered User
    Join Date
    04-20-2021
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    13

    Ignore Blank Cells in Looping Range

    Attached is my Workbook.
    Currently when checking the CheckBox (in A26), it will convert mm to inches in the range specified, but it will add 0's to blank cells. I want it not add anything if the cell is blank.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Ignore Blank Cells in Looping Range

    Try this:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: Ignore Blank Cells in Looping Range

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-20-2021
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Ignore Blank Cells in Looping Range

    TMS unfortunately it just gave me FALSE when I tried your code. But thank you for trying.

    jolivanes yours worked perfectly! Thank you so much!

    Both of your help is much appreciated.

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: Ignore Blank Cells in Looping Range

    Thank you for the come back and good luck.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Ignore Blank Cells in Looping Range

    Ah, not sure why that is. It worked ok for me with your sample file. Ho hum, at least you have a solution.

+ 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. ignore blank values when looping
    By light in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-08-2020, 08:56 AM
  2. [SOLVED] Dynamic Named range Ignore blank cells
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-17-2017, 05:03 AM
  3. [SOLVED] Return non-blank cells from range AND ignore cells with only formula w/o results
    By grafitti in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2014, 08:15 AM
  4. Ignore blank cells and truly blank cells in named range?
    By hschillig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 02:56 PM
  5. [SOLVED] How to ignore blank cells in Range Lookup?
    By Brand012 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-04-2014, 01:42 AM
  6. Ignore Errors on multi-cell range without looping over cells
    By dlh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2011, 08:25 PM
  7. Determine if range has NO Blank Cells without looping through each cell in range
    By Excelenator in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2006, 01:35 AM

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