Vsum failure on expanded view if last row is .Range?
Is there a workaround for this bug?
I have a statement with a bazillion rows, some of which are expandable.
I sum the column using vsum to make sure I don't double count.
The summing works fine in both compressed and expanded views as long as the last row isn't a .Range that expands. If it IS a .Range and you expand the view the vsum term fails to expand properly and yields the wrong number.
Anyone else had this?