Hi,
I am new to writing macros for excel and have a problem I need some
help with:
I want to add a chart using data from the active sheet. I tried the
code below. I know it's writing the active sheet name to CSheet
because I can read it using msgbox so why won't the reference work??
CSheet = ActiveSheet.Name
Charts.Add
ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
ActiveChart.SetSourceData
Source:=Sheets("CSheet").Range("C16:D82"), PlotBy _
:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject, Name:="CSheet"
etc..
--
dve11
------------------------------------------------------------------------
dve11's Profile:
http://www.excelforum.com/member.php...o&userid=31618
View this thread:
http://www.excelforum.com/showthread...hreadid=513129