LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded Excel Objects in PowerPoint resize after editing Barb Reinhardt Excel Discussion (Misc queries) 0 September 21st 09 06:41 PM
Linking Objects from Excel to PowerPoint Eric Excel Discussion (Misc queries) 0 January 22nd 09 11:39 PM
PowerPoint objects in Excel suzdapocho Excel Discussion (Misc queries) 0 March 25th 08 06:34 PM
dimensioning variables Carla101 Excel Programming 8 January 11th 06 11:25 AM
moving excel objects pasted as an image in Powerpoint Iker Excel Programming 1 September 24th 04 04:39 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"