Hello everyone,
I am struggling with a small problem, where I believe that I don't exactly understand the activeSheet property.

I have created a stacked columns chart in vba which works perfectly. It takes data from the sheet I am in and adds a chart below the table. I locate the newly created chart using this code:

Set chtChart  = chtChart.Location (Where:=xlLocationAsObject, Name:="Waterfall")
The problem with this is that it refers to a named sheet. If I want to change the name of the sheet, I would have to change the code. I just want the code to refer to the name of the active sheet I am in.

Having failed to use ActiveSheet.Name for the parameter Name:=, I do not know where to go from here. Any help would be appreciated. Thank you!