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: 2
Default Chart Code problem

One of my collegues was running amacroin excel, and came up with a subscript
error.

I have tried to figure out what is wrong but my knowledge of VB is somewhat
limited - can anyone help

Here is the code

Kaart = "Chart " & y
Windows("QC kontrol udsendelse.xls").Activate
Sheets("Abnormal 1").Select
ActiveSheet.ChartObjects(Kaart).Activate
ActiveChart.SeriesCollection(1).Points(z).Select
With Selection.Border
.Weight = xlHairline
.LineStyle = xlNone
End With

The Macro stops on the following line

ActiveChart.SeriesCollection(1).Points(z).Select


Thanks in advance for any help anyone can offer.

Rgds,
Daniel


 
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
Problem with code kk Excel Discussion (Misc queries) 0 March 15th 08 03:01 PM
Problem with the end of this code EMoe[_29_] Excel Programming 2 June 13th 05 12:44 PM
Code Problem TC[_8_] Excel Programming 8 November 30th 04 07:09 PM
problem with this code Travis Excel Programming 1 January 28th 04 05:43 PM
Code problem Rick[_11_] Excel Programming 1 August 8th 03 04:25 AM


All times are GMT +1. The time now is 06:38 PM.

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"