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.