Thread: Dim SheetName in chart plot
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Smith Michael Smith is offline
external usenet poster
  
Posts: 77
Default Dim SheetName in chart plot
How would I Dim the name of the current sheet, obviously Sheet1 is not
my sheet name

ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R4C1:R14C1"

Thanks in advance
-mike

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote