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