Is there anyway to find the name of the sheet which contains an active chart
using VBA (Excel)?
I want to be able to select the plot and run a macro which set the scales
.... resizes the plot area and then the chart area . I can do everything I
want excpet resize the plot area because I dont know how to find the current
sheet name. Is there any way to find the current sheet name or resize the
plot area without the current sheet name?

Thanks

Chris