align a picture/shape in a Range!

A

Andoni

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
 
J

JK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a macro to run on all files in a folder and save each one? 0
MERGE CELLS 2
Create a report page??? 2
Range.(Cells()) question 3
ms access 2k automation problem with selection 3
Macro column selection 4
I must make certain I have a specific range of numbers present. 3
Append a column with the text "Remarks" 2

Top