View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Dimensioning question chart objects for PowerPoint

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