Chart numbering

R

Robin Clay

Greetings !

I sought help in here this morning - and help I received !

For which, muchos gracias.

But I was wrong - AGAIN !

I had thought that the problem was with numbering the
Chart. It wasn't.

When running, the procedure ground to a halt, and I
deduced what the problem was erroneously.

However.... I thought you kight just be interested in what
the problem REALLY was -

Here's the snatch of code -

.....
.SeriesCollection(1).Name = Worksheets
("Comparison").Range("D2").Value <<-- ERROR !
.....
.SeriesCollection(1).XValues = "=Comparison!R9C3:R" &
HCEEndRow & "C3"
.SeriesCollection(1).Values = "=Comparison!R9C4:R" &
HCEEndRow & "C4"
.....

The REAL problem was that the Range to be plotted
contained #REF!

and for SOME reason, "it" wouldn't accept the line where
the error occurred.

So I have swapped that line and put it AFTER the "Range"
lines -

Voila ! Pas de problem....


Thanks again, guys, for your help.

Regards

Robin

RClay AT haswell DOT com
 
Top