View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sriram N A Sriram N A is offline
external usenet poster
 
Posts: 5
Default calliing seriescollection by name

There is no Activate method for the Series Object in the Excel object model.
However the Chart object does have both Activate and Select methods.

You could avoid trial and error by spending some time to study the Excel
object model (press F2 in the VBA editor).

"R.VENKATARAMAN" wrote in message
...
so far I thought "activate" and "select" are more or less synonymous.
But they are not.
at the same time if I use
chart("chart1").activate ( or select) both work.

what is the logic. Or is there flaw in my logic?