Posted to microsoft.public.excel.programming
|
|
Referencing sheets/objects
Hi DVE11,
Change:
Name:="CSheet"
to
Name:=CSheet
---
Regards,
Norman
"dve11" wrote in message
...
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
|