2007 - ShowPrecedents Q

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dana DeLouis - 27 Sep 2007 23:53 GMT

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

Signature

Dana DeLouis
Windows XP & Excel 2007

Reply to this Message

Sandy Mann - 28 Sep 2007 00:02 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>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."
[quoted text clipped - 14 lines]
>
> TIA. :>~

Reply to this Message

Wondering - 28 Sep 2007 03:33 GMT

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

>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."
[quoted text clipped - 14 lines]
>
> TIA. :>~

Reply to this Message

Dana DeLouis - 28 Sep 2007 14:52 GMT

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

Signature

Dana

> 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."
[quoted text clipped - 14 lines]
>
> TIA. :>~

Reply to this Message