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. :>~
--
Dana DeLouis
Windows XP & Excel 2007

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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"Dana DeLouis" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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. :>~
> --
> Dana DeLouis
> Windows XP & Excel 2007
>
>
>
>

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

"Dana DeLouis" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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. :>~
> --
> Dana DeLouis
> Windows XP & Excel 2007
>
>
>

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. :>~

--
Dana



"Dana DeLouis" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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. :>~
> --
> Dana DeLouis
> Windows XP & Excel 2007
>
>
>