Getting a cell's position in points?

T

Tarheel

Board Regular
Joined
Jul 30, 2002
Messages
158
Hi all,

I am using the AddPicture method (Shapes) to insert a bunch of images into a worksheet for a report. The AddPicture method requires a parameter (Left,Top) for the position to insert the picture, which is measured in points relative to the upper-left corner of the document.

I want to insert these pictures into cells, and I do not know how to calculate the relative position of a cell from the upper-left corner of the document. Is there a way to do this?

Thanks,
Richard
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Richard -

You can't insert a picture or other object into a cell, but you can float it in the drawing layer above the worksheet, aligned with cells.

Expanding on the help files' example, and assuming B2 is large enough:

Code: 
With ActiveSheet
    .Shapes.AddPicture "c:\microsoft office\clipart\music.bmp", _
        True, True, .range("B2").left, .range("B2").Top, _
        .Range("B2).Width, .Range("B2").Height

You can substitute any range for "B2", such as a larger address "B2:F20", a named range "MyRange", or a VBA range variable rngPicture.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
 
Upvote 0
Jon,

Thank you so much for the quick reply. It works fabulously, of course.

I did know that you cannot insert an image into a cell, I meant that I wanted the image aligned with the cell. Thanks for pointing that out and reminding me.

Best regards,
Richard
 
Upvote 0
Hello to all :-)
i need to add one image on one excel file ...
but i create it in a asp web page ,
and then i want people can save it with the image

i use some instruction like this :

Code: 
Response.ContentType = "application/vnd.ms-excel" 
FileName = "NAME-(" & Day(Date) & "-" & Month(Date) & "-" & Year(Date) & " " & Hour(Now) & Minute(Now) & ").xls"
Response.AddHeader "Content-Disposition", "inline; filename=" & FileName
Response.Write "<html xmlns:x=""urn:schemas-microsoft-com:office:excel"">"


actually the image it is a simple link to an Url

Code: 
<img src= <%=url%> alt="<%=alt_text%>">

:help:
how i can use (if i can) .AddPicture to add it in a binary format ?
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Word Header Image - Layout Options
Replies
2
Views
168
mikeymay
M
O
  • Solved
VBA - floating photo
Replies
3
Views
341
RoryA
RoryA
M
  • Question Question
Please help me to correct Excel VBA code!
Replies
1
Views
329
Minh Tuan VN
M
M
  • Solved
Word Header Text
Replies
1
Views
143
RoryA
RoryA
KlausW
  • Solved
Excel VBA Error - Unable to get the Insert property of the Picture Class
Replies
7
Views
344
KlausW
KlausW

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top