Thanks for the correction Tom

I think it is a stupid name "Pictures"


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Tom Ogilvy" wrote in message ...
Control toolbox controls are selected, but not controls from the forms
toolbar or objects from the drawing toolbar (textboxes specifically).

--
Regards,
Tom Ogilvy


"Ron de Bruin" wrote in message
...
Hi Blewyn

Activesheet.Pictures.Select

This will also select controls from the Forms and Control Toolbox.
Maybe it is no problem for you?

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Tom Ogilvy" wrote in message
...
with Shapes("Picture 1")
.Top = range("B9").Top
.Left = range("B9").Left
End With

You can also specify the Width and Left properties or scale the picture.
If
you need sample code, turn on the macro recorder and configure the
picture
manually.

Activesheet.Pictures.Select

--
Regards,
Tom Ogilvy

"blewyn" wrote in message
om...
How do I specify the position of a picture on a worksheet with a macro
? Also, is there a way to have a macro select all the pictures on a
page, regardless of their object names ?

Thanks,

Blewyn