| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
| Shape Range | Charts and Charting in Excel | |||
| I know selected picture is a shape but typename says is picture | Excel Programming | |||
| Error 1004 using Shapes.Range().Align | Excel Programming | |||
| align text in the center of a range of cells | Excel Programming | |||
![Andoni[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
