LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Chart VB Code Syntax

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
please help with syntax in code tracks via OfficeKB.com Excel Programming 17 November 7th 06 08:21 PM
Help with Syntax in Code Ken Hudson Excel Programming 1 October 6th 06 05:22 PM
Help with Syntax in Code Tom Ogilvy Excel Programming 0 October 6th 06 04:36 PM
Syntax of VBA Code Ken Hudson Excel Programming 1 September 14th 05 10:09 PM
help with code/syntax Jay Baxter Excel Programming 0 February 26th 04 08:11 PM


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"