2007 - ShowPrecedents Q

D

Dana DeLouis

I would like to ask if anyone thinks this is a bug w/ Excel 2007.
I did not catch a problem recently because I relied on "ShowPrecedents."
The code below will set the problem up.
Cell A2 correctly shows that there are two cell ranges.
Cell A4 shows only 1 range, and not the second D4:H4.
I didn't find anything in Microsoft's kb articles.
Any thoughts, or is it just my system with this problem?

Sub SetUp()
[A2].Formula = "=SUM(D2:F2)/SUM(F2:H2)"
[A4].Formula = "=SUM(D4:F4)/SUM(D4:H4)"

[A2].ShowPrecedents
[A4].ShowPrecedents
[A4].Select
End Sub


TIA. :>~
 
S

Sandy Mann

I get the same result in XL97 - glad to hear that I am uptodate in
something! <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
W

Wondering

Excel 2007. Confirmed if the formulas are entered by VBA. Entered manually,
everything is fine.
 
D

Dana DeLouis

Thanks everyone for the feedback. It appears that the problem occurs when
two ranges share the same first cell.
For another example, it appears that only the first group of cells are
flagged by ShowPrecedents. The second function's range is ignored.

=SUM(A1:C1)+SUM(A1:A3)
=SUM(A1:A3)+SUM(A1:C2)

That's too bad. I use "ShowPrecedents" often.
It's a great tool. Didn't know it had "problems."
Thanks for the feedback. :>~
 
Top