Originally Posted 1 November 2016, 11:24 am ESTAfter creating a subtotal columns with out values show a Zero.
I would like to remove the zeros.
For Row = 1 To gdList.Rows.Count - 1
If gdList.Rows(Row).IsNode = True Then
For ThisCol = 5 To 7
If gdList(Row, ThisCol) = 0 Then gdList(Row, ThisCol) = " "
When the code finds a zero - gdList(Row, ThisCol) = " " does not work.
gdList(Row, ThisCol) still = 0