Hi

This helpful code snippet:
MsgBox ActiveChart.Parent.TopLeftCell.Address

comes from a John Walkenbach post 8 years ago:
http://groups.google.com/group/micro...wse_thread/thr
ead/ff952bea085dfdaa/e76f6ed598be6b4f?hl=en&lnk=st&q=chart+topleftcell#e76f6
ed598be6b4f

It was very helpful. However can someone tell me why the Parent is needed -
intuitively, I'd have thought the the top left cell was a property of the
active chart itself, not its parent, but obviously not..?

Thanks

Tim

Because the chart is contained within a chartobject which is what lays on
the worksheet, so you need the chart's parent to see where abouts in the
sheet it is positioned.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Tim Childs" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> This helpful code snippet:
> MsgBox ActiveChart.Parent.TopLeftCell.Address
>
> comes from a John Walkenbach post 8 years ago:
> http://groups.google.com/group/micro...wse_thread/thr
> ead/ff952bea085dfdaa/e76f6ed598be6b4f?hl=en&lnk=st&q=chart+topleftcell#e76f6
> ed598be6b4f
>
> It was very helpful. However can someone tell me why the Parent is
> needed -
> intuitively, I'd have thought the the top left cell was a property of the
> active chart itself, not its parent, but obviously not..?
>
> Thanks
>
> Tim
>
>

Hi

that is very helpful - thanks

Tim

I like the signature line re: email!

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Because the chart is contained within a chartobject which is what lays on
> the worksheet, so you need the chart's parent to see where abouts in the
> sheet it is positioned.
>
> --
> ---
> HTH
>
> Bob
>
>
> (there's no email, no snail mail, but somewhere should be gmail in my
addy)
>
>
>
> "Tim Childs" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi
> >
> > This helpful code snippet:
> > MsgBox ActiveChart.Parent.TopLeftCell.Address
> >
> > comes from a John Walkenbach post 8 years ago:
> >
http://groups.google.com/group/micro...wse_thread/thr
> >
ead/ff952bea085dfdaa/e76f6ed598be6b4f?hl=en&lnk=st&q=chart+topleftcell#e76f6
> > ed598be6b4f
> >
> > It was very helpful. However can someone tell me why the Parent is
> > needed -
> > intuitively, I'd have thought the the top left cell was a property of
the
> > active chart itself, not its parent, but obviously not..?
> >
> > Thanks
> >
> > Tim
> >
> >
>
>

"Tim Childs" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> that is very helpful - thanks
>
> Tim
>
> I like the signature line re: email!

Yeah, we have to go to such lengths to avoid the sniffers getting our email
addies (still get hundreds every week though).