2007 - ShowPrecedents Q

  • Thread starter Thread starter Dana DeLouis
  • Start date Start date
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. :>~
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Excel 2007. Confirmed if the formulas are entered by VBA. Entered manually,
everything is fine.
 
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. :>~
 
Back
Top