Just an unpdate - you can refer to several range names in
your code if you seperate them by commas and keep the
filenames in apostrophies. This example shows two ranges
but I think the syntax is what you're trying to get at for
your three range name question.
ActiveChart.SeriesCollection(1).Values = "='yourfile.xls'!
Rname1, 'yourfile.xls'!Rname2"
Ragards
John Mansfield
-----Original Message-----
Hi,
I have three cells named and want to use that name in a
vba chart procedure
for a xl3DColumnStacked chart
ActiveChart.SeriesCollection(1).Values = sheet1.Range
(scol1v)
I used in the procedu
Dim scol1v As String
Let scol1v = "ThreeValues"
Meaningless note:
I used sheet1 as Name and CodeName
In the excel GUI you find the name "ThreeValues" is
defined as this
reference:
'sheet1'!$A$1;'sheet1'!$A$4;'sheet1'!$A$6
I thougt it just was to specify the sheet + name, but the
debbugger doesn't
like that. what am i doing wrong? Shall I use array() or
something? Please
give me a syntax or procedure that works that I can look
at...
Regards
.
|