Hi,

I hope someone can help me out here. I`m having trouble using a define
dynamic range that I added as a name like this:

ActiveWorkbook.Names.Add Name:="myX", RefersToR1C1:= _
"=""FORSKYVNING(sheet1!$G$10;0;0;1;sheet2!$B$7 )"""

The word FORSKYVNING is just the norwegian translation of OFFSET
think so don`t mind about that.

To use the named range for the xvalues in my chart I tried th
following:

Set srs = Currentchart.SeriesCollection.NewSeries
srs.XValues = ActiveWorkbook.Names.myX

, but I get that "object doesn`t support property or merthod". Doe
anyone know the rigth way to assign myX to srs.XValues

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