Run Time Error -2147024809 (80070057)

[shiftyspina]

Hi

I keep getting this run time error and my command call telling me the specific object "userform1" cannot be found......

I cant see what i am doing wrong here, maybe a bit of code is wrong somewhere does anyone have any ideas?

thanks

Dan

[6StringJazzer]

The code fails at this line of UserForm_Initialize

Please Login or Register  to view this content.

This is because there is no chart with the name "Chart 17". (This is a pet peeve of mine for the VBA debugger. Sometimes instead of showing you the actual line of code where it halted, it shows the call of the Sub containing the failed line of code.)

Here is a complete list of all the charts on that sheet and their names. If you delete charts and create new ones, Excel does not re-sequence the names; it leaves holes.

1 Chart 1
2 Chart 2
3 Chart 3
4 Chart 4
5 Chart 5
6 Chart 6
7 Chart 7
8 Chart 8
9 Chart 9
10 Chart 10
11 Chart 11
12 Chart 12
13 Chart 13
14 Chart 14
15 Chart 15
16 Chart 16
17 Chart 24
18 Chart 25
19 Chart 27
20 Chart 28
21 Chart 29
22 Chart 30
23 Chart 31
24 Chart 32
25 Chart 33
26 Chart 35
27 Chart 36
28 Chart 37
29 Chart 38
30 Chart 39
31 Chart 40
32 Chart 41
33 Chart 42
34 Chart 43
35 Chart 44
36 Chart 45
37 Chart 46
38 Chart 47
39 Chart 48
40 Chart 49
41 Chart 50
42 Chart 51
43 Chart 52
44 Chart 53
45 Chart 54
46 Chart 55
47 Chart 56
48 Chart 57
49 Chart 58
50 Chart 59
51 Chart 60
52 Chart 61
53 Chart 63
54 Chart 65
55 Chart 66
56 Chart 67
57 Chart 68
58 Chart 71
59 Chart 72
60 Chart 73
61 Chart 74
62 Chart 75
63 Chart 76
64 Chart 77
65 Chart 78
66 Chart 79
67 Chart 80
68 Chart 81
69 Chart 82
70 Chart 83
71 Chart 84
72 Chart 85
73 Chart 86
74 Chart 87
75 Chart 88
76 Chart 89
77 Chart 90
78 Chart 91
79 Chart 92
80 Chart 93

[Izandol]

If you will set VBE to break in class module you will see actual error line.

[shiftyspina]

Thanks for explaining that, when i was building the form it kept picking up the wrong chart e.g chart_20 in the sheet, i had to code as chart_15 in the code and couldnt understand why it was doing that, thank you very much for explaining that and getting back to me