referencing a dynamic array
 

Hi,
Thanks for your responce, it was informative.

What I`m trying to do is tell excel at what x-value to start plotting
So I guess I can set

With Activechart.Axes(xlValue)
.MinimumScale = CurrentChart.SeriesCollection(1).points(1)
End With

, or at least that was my idea. But I get error msg like sometin
"can`t access minimumscale property of axes object". With an intege
isnstead of the
"CurrentChart.SeriesCollection(1).points(1)", it works fine

--
hk
-----------------------------------------------------------------------
hke's Profile: http://www.excelforum.com/member.php...nfo&userid=155
View this thread: http://www.excelforum.com/showthread.php?threadid=27361