Hi all experts,
I'm writing a macro by resizing the chart, and the VBA codes as below.
Dunno why when I run the marco, it changed all the charts size in the same spreadsheet, just wondering what should I add to the code, so that the macro is only run on the selected chart?
Really appreciate if you guys can help me with this. And thank you so much!
For j = 1 To ActiveSheet.Shapes.Count
If ActiveSheet.Shapes(j).Type = msoChart Then
ActiveSheet.Shapes(j).Width = 360
ActiveSheet.Shapes(j).Height = 201.6