+ Reply to Thread
Results 1 to 5 of 5

Ignore Cell if it is blank (but still has formula)

  1. 07-25-2013, 12:02 PM #1
    thelegazy
    thelegazy is offline
    Forum Contributor
    Join Date
    06-01-2012
    Location
    va
    MS-Off Ver
    2007
    Posts
    163

    Ignore Cell if it is blank (but still has formula)

    I have the following code

    Please Login or Register  to view this content.
    Which will comb through the range and if there is any value it will make a section, but I have a LEFT formula in that range and if it doesn't return a value it still takes it into consideration because there is a value. How do I change it to take cells only that show values (not that show nothing, but still have formulas?

    Any help is appreciated.
    Reply With QuoteRegister To Reply
  2. 07-25-2013, 12:17 PM #2
    LaffyAffy13
    LaffyAffy13 is offline
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Ignore Cell if it is blank (but still has formula)

    This method isn't the greatest way, but it still may work. It does completely remove your LEFT formula from each blank cell, though. Will that be an issue?

    Please Login or Register  to view this content.
    ~~LaffyAffy13~~

    If I have helped you solve your problem, please be sure to click at the bottom left of my post.

    Thanks.
    Reply With QuoteRegister To Reply
  3. 07-25-2013, 12:17 PM #3
    GaidenFocus
    GaidenFocus is offline
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Ignore Cell if it is blank (but still has formula) 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 07-25-2013, 12:20 PM #4
    thelegazy
    thelegazy is offline
    Forum Contributor
    Join Date
    06-01-2012
    Location
    va
    MS-Off Ver
    2007
    Posts
    163

    Re: Ignore Cell if it is blank (but still has formula)

    Can you add it to the original code? Sorry, I'm not as familiar with VBA as I should be.
    Reply With QuoteRegister To Reply
  5. 07-25-2013, 12:30 PM #5
    LaffyAffy13
    LaffyAffy13 is offline
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Ignore Cell if it is blank (but still has formula) 

    Please Login or Register  to view this content.
    Last edited by LaffyAffy13; 07-25-2013 at 12:30 PM. Reason: code tags
    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] An INDEX MATCH formula has blank cell - need to ignore or delete
    By rls231 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2013, 11:13 PM
  2. Formula (SUM & IF) to ignore a blank cell?
    By DORourke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 06:48 PM
  3. [SOLVED] How to ignore a blank cell
    By TamTurner in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2012, 12:48 PM
  4. How? Ignore cell if blank in an IF formula.
    By n2lectual in forum Excel General
    Replies: 7
    Last Post: 03-26-2008, 03:46 PM
  5. Getting formula to ignore blank cells
    By CDM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2006, 06:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1