Thread: How to select one by one picture on my sheet with VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default How to select one by one picture on my sheet with VBA?

Hello Marko,

A Picture belongs to the Shapes class of the Worksheet it is on.

Dim Pic As Shape
For Each Pic In Activesheet.Shapes
If Pic.Type = msoPicture Then
Pic.Select
End If
Next Pic

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=513885

Reply With QuoteReply With Quote