Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
please help with syntax in code | Excel Programming | |||
Help with Syntax in Code | Excel Programming | |||
Help with Syntax in Code | Excel Programming | |||
Syntax of VBA Code | Excel Programming | |||
help with code/syntax | Excel Programming |