When you make a chart, you use an array of cells. I want to use the sam
row to produce values for the y-axis in several charts. I can no
specify explicitly in the macro that I want the array to be for exampl
c3:c23, because the length of the array changes.

If I could define an array which starts at, say c3, and then als
specify how many moore elements (from the third row with columns i
ascending order) the array should contain (by referring to a cell tha
holds this info) that would be fine.

help is much appreciated!

--
hk

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