View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vickie_raven vickie_raven is offline
external usenet poster
 
Posts: 4
Default help new to vba - charts??

I have a chart on a work sheet, and the sheet is called "Operator
Input" and the charts name is "rate"

My question is - How do i select the chart?

i have tried this

ActiveSheet.ChartObjects("rate").Select

and i get an error

but this seems to work

ActiveSheet.ChartObjects("rate").Activate

is the Activate the only way to do the selection??


Thanks in advance

Vickie