æçè¿æ®µä»£ç è½ç¶ä¸æ¯ä½ æéè¦ç,ä½æè®¸å¯¹ä½ æç¨.
å°Aåæåæ°æ®è¡ä»¥ä¸çææBåå¾ç大å°è°æ´ä¸ºæå¨åå
大å°
Sub å°Aåæåæ°æ®è¡ä»¥ä¸çææBåå¾ç大å°è°æ´ä¸ºæå¨åå
大å°()
Dim Pic As Picture, i&
i = [A65536].End(xlUp).Row
For Each Pic In Sheet1.Pictures
If Not Application.Intersect(Pic.TopLeftCell, Range("B1:B" & i)) Is Nothing Then
Pic.Top = Pic.TopLeftCell.Top
Pic.Left = Pic.TopLeftCell.Left
Pic.Height = Pic.TopLeftCell.Height
Pic.Width = Pic.TopLeftCell.Width
End If
Next
End Sub
温馨提示:答案为网友推荐,仅供参考