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.
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.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks