Dimensioning question re: chart objects for PowerPoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following for/next loop in Excel

For Each objcht In sht.ChartObjects

In Excel I dimension it as

Dim objcht As ChartObject

I want to do something with a chart object through PowerPoint and I have a
similar For/Next loop

For Each chtobj In XLSheet.ChartObjects

I've tried dimensioning it like this:

Dim chtobj As Application.Excel.ChartObjects

When I try to RUN it, I get an application mismatch on the immediately
preceding line. Can someone assist?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract Chart Titles from graphs 1
VBA chart formatting 2
Check for the existence of data labels 2
I need to give index number to charts 3
Displaying series list from each chart sheet in workbook 5
Redefining chart series 1
delink all charts in worksheet 3
For each objcht in ... 1

Back
Top