Hi!

How can i select one by one picture on my sheet through VBA
"for each pic in Activesheet.pictures...?
and how do i have to define(dim) my picture, dim pic as???
please help. thanks!

Marko Svaco

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

dim pic as picture

should work ok, too.

If you use the object browser (F2 in the VBE), you can show hidden elements and
still see the picture object.

marko wrote:

Hi!

How can i select one by one picture on my sheet through VBA
"for each pic in Activesheet.pictures...?
and how do i have to define(dim) my picture, dim pic as???
please help. thanks!

Marko Svaco

--

Dave Peterson

Thanks a million!!!
it works perfectly!!!!

Marko Svaco

Thanks!

Marko Svaco