Thread: 3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) )
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default 3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) )
Hi Marie,

This worked. Is your solution the same?

Mine was wrong, I forgot that the seriescollection needs a string address.

ActiveChart.SeriesCollection(1).Values = "=" & ActiveWorkbook.Name & "!" &
scol1v
I don't want to use this

I fail to understand what you *do* want to use, sorry. Could you try and
explain that?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With QuoteReply With Quote