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 ***

Dim SheetName in chart plot
 

Hello Mike,

If by current you mean the active worksheet then...

ActiveChart.SeriesCollection(1).XValues = "=" & ActiveSheet.Name
"!R4C1:R14C1"

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=50306