Posted to microsoft.public.excel.programming

Andoni[_18_] Andoni[_18_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Manually changing a picture (shape) name property	ker_01	Excel Discussion (Misc queries)	4	April 3rd 23 07:01 PM
Shape Range	kuhrty	Charts and Charting in Excel	3	April 22nd 10 05:12 PM
I know selected picture is a shape but typename says is picture	Carlos Lozano	Excel Programming	3	July 24th 04 05:44 PM
Error 1004 using Shapes.Range().Align	juergen	Excel Programming	3	June 25th 04 11:14 AM
align text in the center of a range of cells	nikolaosk[_9_]	Excel Programming	4	October 19th 03 09:44 AM

All times are GMT +1. The time now is 06:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us