View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default 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/