How to got the position of a cell/range in pixels (from the left-top corner) ?

C

charon1999

Hi everybody,

I am new to programming in Excel and can't get any further with the
following problem:

What i want to chieve is to insert a picture "into" a specific "cell"
(range) in my worksheet.
I have found the function: AddPicture(Filename As String, LinkToFile As
MsoTriState, SaveWithDocument As MsoTriState, Left As Single, Top As
Single, Width As Single, Height As Single) As Shape

In the help it says that to define the position I need to know the
pixels from the left-top corner:
- Left Required Single. The position (in points) of the upper-left
corner of the picture relative to the upper-left corner of the
document.
-Top Required Single. The position (in points) of the upper-left
corner of the picture relative to the top of the document.

This functionality would be really great for me.
However the problem is that I don't have the position in pixels.
I only know the cell-coordinates (ex. "2/25" or "B25" )

Does anybody know how to find out the position in pixels for a given
cell or a range ?

Thanks in advance for any help.

Bye

Char
 
B

Bob Phillips

Charon,

A cell has a top and left property tyhat you can use, loike so

Dim myDocument As Worksheet
Set myDocument = Worksheets(1)
myDocument.Shapes.AddPicture _
"C:\Documents and Settings\Bob\My Documents\My
Pictures\classic_beetle.jpg", _
True, True, Range("B25").Left, Range("B25").Top, 70, 70


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Top