Hi,

Thanks for your detailed explanation

Seeing your along and comparing with macro recorder am able to make sense of
the kind of syntax needed to do similar things.

Im now able to understand that even chartsheets work on the basis of the
chart objects syntax. (wonder why MS has written in the help about
chartobjects saying "Represents an embedded chart on a
worksheet." when even chartsheets use the chartobject concept.)

Grateful for your Shift + Click for chart name tip.

Thanks a lot,
Hari
India

"Andy Pope" wrote in message
...