Thread: 3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) )
View Single Post
  #2   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,

Please
give me a syntax or procedure that works that I can look at...


ActiveChart.SeriesCollection(1).Values =
Activeworkbook.Names("YourName").RefersToRange

Regards,

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

Reply With QuoteReply With Quote