如何在EXCEL里用VBA让新添加的图表定位在指定的单元格

Question

如题所述

Answer 1

如将图标1对齐到G10单元格：
Sub A()
Dim x As Double, y As Double

x = Range("G10").Left
y = Range("G10").Top

Sheet1.Shapes("图表 1").Left = x
Sheet1.Shapes("图表 1").Top = y
End Sub