Can not change Category Names for Axis
 

Hello everyone,

Here is my problem...

I have a chart with a secondary category axis, and I need to chang
names on it. The code I have used to work fine and now it give an erro
"Unable to set the CategoryNames property for Axis class".

And I think it is because CategoryNames is empty sometimes, but I a
not sure, because everytime I add myAxis object to Watch list Exce
crashes (I mean it gives me "Program preformed an unperforme
operation..." blabla "Sorry for the inconvinience").

here is my code

Set myChart = Sheets.Application.ActiveSheet.ChartObjects("Char
1").Chart
With myChart

Set myAxis = .Axes(1, xlSecondary)
With myAxis
.CategoryNames = myCatNames 'myCatNames is an array
End With
End With


myCatNames - is an array which gets values from a specific range. An
this one works fine, because I am able to add to watch list and se
what is going on with it.

Thank you all for you feedback if any.
Ivan


P.S. Maybe when .CategoryNames is empty and I am trying to assign a
array to it then it raises error. If that's the case how to ReDim a
object property (.CategoryNames) ??

--
Intellihom
-----------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=147
View this thread: http://www.msusenet.com/t-187045634