ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Excel VBA Picture¤ñ¤j¤p§R°£

[µo°Ý] Excel VBA Picture¤ñ¤j¤p§R°£

¥Ø«e¥¿¦b¼g§@ªºExcel VBA¤¤¸I¨ì¤@­Ó°ÝÃD
¨C­Ó¤À­¶¸ÌÀY¦³¶W¹L2±iªºPicture
ÀɦW¬OÀH¾÷ªº¡APicture XXXX

·Q°Ý»¡«ç¼Ëªºµ{¦¡¡A¥i¥HÅý¤À­¶¦Û¤v¥h¤ñ¸û¹Ï¤ùªº¤Ø¤o¤j¤p
¨Ã¥u«O¯d³Ì¤jªº¨º¤@±i¡A¨ä¾l³£§R°£

¥u­n¯à°÷·d©w¤@±i¤À­¶¡A¨ä¾l¥ÎLoop¤è¦¡´N¥i¥H¸Ñ¨M¤F
·Q°Ý¬Ý¬ÝªO¤Wªº°ª¤â¯à¤£¯à´À§Ú¸Ñµª
·P®¦
thank you!

Sub Q_9822003045()

Dim obj(1)

If Pictures.Count <= 1 Then Exit Sub
Set obj(1) = Pictures(1)
For Each obj(0) In Pictures
  If (obj(0).Width * obj(0).Height) > _
     (obj(1).Width * obj(1).Height) Then
      Set obj(1) = obj(0)
  End If
Next

For Each obj(0) In Pictures
  If obj(0).Name <> obj(1).Name Then
     obj(0).Delete
  End If
Next

End Sub

TOP

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2014/9/15 17:18): ¥iªþ¤W§AªºÀÉ®×

¦^´_ 2# bobomi


ÁÂÁ©pªº¦^ÂÐ

¥i¥H¸ò§A­nÀÉ®×Á@Á@¶Ü?

§Ú½Æ»s¦¨µ{¦¡½X«á¡AÁ`·|¦³¿ù»~ªº°T®§µo¥Í><

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD