f2e4
06-11-2008, 03:33 AM
Hey guys,
I have a listbox that is populated from a pivottable.
The ListFillRange for the Listbox is a Dynamic Named Range for the 1st column of the Pivottable.
I have the listbox set up to show both columns of the pivottable.
Some of the items listed have a sum of 0 in the second column.
Is there a way to hide this item if the value in the second column = 0.
Thanks
F
I have a listbox that is populated from a pivottable.
The ListFillRange for the Listbox is a Dynamic Named Range for the 1st column of the Pivottable.
I have the listbox set up to show both columns of the pivottable.
Some of the items listed have a sum of 0 in the second column.
Is there a way to hide this item if the value in the second column = 0.
Thanks
F