Referencing sheets/objects

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 Where:=xlLocationAsObject, Name:="CSheet"
etc..

Hi DVE11,

Change:

Name:="CSheet"
to
Name:=CSheet


---
Regards,
Norman



"dve11" <dve11.23bl8a_1140089702.404@excelforum-nospam.com> wrote in message
news:dve11.23bl8a_1140089702.404@excelforum-nospam.com...
>
> 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 Where:=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
>