+ Reply to Thread
Results 1 to 2 of 2

Blank cells displayed as Zero in an Excel Listview

  1. #1
    Registered User
    Join Date
    11-29-2018
    Location
    Manchester, england
    MS-Off Ver
    Office 365
    Posts
    1

    Blank cells displayed as Zero in an Excel Listview

    I'm trying to display data in an Excel ListView

    However the range contains a lot of blank cells that are displayed as zero in the listview

    I don't want to see the zeros only the ones containing data

    The code below only removes the zero's from Column 1, If listItem = "0" Then listItem = ""

    the other column's from 2 onwards still contain zeros in the cells that are empty: -

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,896

    Re: Blank cells displayed as Zero in an Excel Listview

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

+ 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] No date displayed in datepicker if cell is blank
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 02:41 PM
  2. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  3. [SOLVED] Plot where blank fields are ignored, not displayed.
    By kbka in forum Excel General
    Replies: 4
    Last Post: 07-17-2012, 11:23 AM
  4. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  5. listview in excel vba
    By albert28 in forum Excel General
    Replies: 1
    Last Post: 08-13-2011, 05:15 AM
  6. [SOLVED] Userform is blank when displayed
    By SteelDetailer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 02:05 AM
  7. Why do cells in Excel print shorter than displayed on-screen?
    By Mary Madeline in forum Excel General
    Replies: 0
    Last Post: 10-21-2005, 03:05 PM
  8. [SOLVED] 5th-odr poly coefficients automatically displayed in excel cells?
    By jason1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2005, 01: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