align a picture/shape in a Range!
 

Hi!
Many Thanks in advance!

I have a few pictures, and or shapes.
I do not want to change the Height or Width or my picture

I have a range("A1:H10")
How can I:

insert my picture as follws
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
so; keep my picture aligned horizontally and vertically in the middl
of my range "A1:H10"


See you

--
Message posted from http://www.ExcelForum.com

align a picture/shape in a Range!
 

Unless your pictures are all different sizes, I would size cells A1:H10 to
the exact size of the picture and paste in A1.

Regards
Jim Kobzeff

"Andoni " wrote in message
...
Hi!
Many Thanks in advance!

I have a few pictures, and or shapes.
I do not want to change the Height or Width or my picture

I have a range("A1:H10")
How can I:

insert my picture as follws
HorizontalAlignment = xlCenter
VerticalAlignment = xlCenter
so; keep my picture aligned horizontally and vertically in the middle
of my range "A1:H10"


See you!


---
Message posted from http://www.ExcelForum.com/