Posted to microsoft.public.excel.programming

Scooter

external usenet poster

Posts: 43

ChartObjects

Why does this work

ActiveSheet.ChartObjects("1020").Activate

but this doesnt

Dim ChartName(12) As String
ChartName(0) = "1020"
I = 0
ActiveSheet.ChartObjects(ChartName(I)).Activate

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
F1 help for ChartObjects	John	Excel Programming	1	October 21st 06 02:36 AM
ChartObjects	Scott	Excel Programming	1	June 30th 06 12:23 AM
Problems with ChartObjects	pwermuth[_5_]	Excel Programming	5	July 12th 05 11:19 PM
Not allow selection of chartobjects ?	Gunnar Johansson	Charts and Charting in Excel	0	May 8th 05 01:40 PM
ChartObjects	Nick	Excel Programming	2	August 19th 04 12:04 PM

All times are GMT +1. The time now is 08:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us