I would like to have my macro graph the sheet I am on without having t
type in different names as I change different files. The SourceDat
looks like this right now:

ActiveChart.SetSourceData Source:=Sheets("sName").Range("A1:B400")
PlotBy _
:=xlColumns

Is there any way I can get sName to be the name of the curren
worksheet I am viewing

--
Loss
-----------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...fo&userid=2481
View this thread: http://www.excelforum.com/showthread.php?threadid=38368