ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Align a picture/shape in the middle of a range("A1:H10") (https://www.excelbanter.com/excel-programming/308038-align-picture-shape-middle-range-a1-h10.html)

Andoni[_20_]

Align a picture/shape in the middle of a range("A1:H10")
 
Hi!
Many Thanks in advance!

I have a few pictures, and or shapes, not necesarily the pictures hav
all the same size.
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



All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com