Excel 如何在VBA里返回公式所在单元格的坐标

2025-04-05 09:49:47
推荐回答(1个)
回答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