请教：如何取得EXCEL表中图片所在的单元格行号？

liunis 发布于 2023-02-23 19:41， 779 次点击

如何取得EXCEL表中图片所在的单元格行号？以图片顶部所点单元格为准

只有本站会员才能查看附件，请登录

3 回复

zhken2023-02-26 20:46

For Each sh In sSheet.Shapes
sh.Left =sh.TopLeftCell.Left
sh.Top =sh.TopLeftCell.Top
sh.Width =sh.TopLeftCell.Width
sh.Height =sh.TopLeftCell.Height
endfor

zhken2023-02-26 20:51

For Each sh In sSheet.Shapes
sh.Left =sh.TopLeftCell.Left
sh.Top =sh.TopLeftCell.Top
sh.Width =sh.TopLeftCell.Width
sh.Height =sh.TopLeftCell.Height
sh.address=sh.TopLeftCell.Address
endfor

schtg2023-02-27 06:25

回复 3楼 zhken

谢谢！