+ Reply to Thread
Results 1 to 3 of 3

Displaying blank cells instead of null values...

  1. #1
    Registered User
    Join Date
    09-13-2008
    Location
    Oregon, USA
    Posts
    5

    Displaying blank cells instead of null values...

    I'm working on a sheet with 10 cells running custom functions. Each of the functions are dependent on a single cell being populated with a URL. I'd like the sheet to not display the null values for the 10 cells containing the functions - in other words if a specific cell isn't populated, the cells executing those functions would be blank.

    In the past I've done this with a simple if block prior to the unique contents of the cell. An example would be
    Please Login or Register  to view this content.
    So just to be as specific as possible, lets say A1 contains the URL that is being parsed by these functions. How would I edit the formula below to display nothing if A1 is blank?
    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612
    You can include your UDF in the if formula:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-13-2008
    Location
    Oregon, USA
    Posts
    5
    Beautiful and way too obvious for my brain to have thought of. Thanks

+ 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. Copying down through blank cells
    By adamhenderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2008, 09:49 PM
  2. How to create user form that displays values from cells
    By TomT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2008, 02:57 AM
  3. Excel doesn't think blank cells are not really blank?
    By leonnord in forum Excel General
    Replies: 3
    Last Post: 08-01-2007, 02:34 PM
  4. leaving cell blank as a result of two blanks cells
    By Mister Big Shot in forum Excel General
    Replies: 3
    Last Post: 03-24-2007, 03:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1