Selecting a graph using macro

**Dagwood2005** · 03-20-2007, 05:31 PM

Hello,

What is the VBA code for selecting a chart to work on? For instance, the code for selecting a worksheet named "Dashboard" is:

Sheets("Dashboard").Select

What is the code for selecting a particular chart?

Thanks.

**VBA Noob** · 03-20-2007, 05:35 PM

Hi,

Best way to learn is use the VBA recorder.

Record selecting the chart and see what code it produces

VBA Noob

**Dagwood2005** · 03-20-2007, 05:39 PM

i've tried that an i have the code for it---but i need to refer to a specific graph every time I run a macro. the line of code i have written will not let me refer to the name of the chart every time i run the macro.

**antoka05** · 03-20-2007, 05:41 PM

You cna also use this code:

ActiveSheet.ChartObjects("Chart1").Activate
or
ActiveSheet.ChartObjects(1).Activate

Regards,
Antonio

**VBA Noob** · 03-20-2007, 05:45 PM

Try

Please Login or Register  to view this content.

Change chart 2 to your chart name

VBA Noob

Selecting a graph using macro

LinkBack

Thread Tools

Rate This Thread

Display

Selecting a graph using macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions