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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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
180
mikeymay
M
L
  • Question Question
Automating "Place in Cell" for Pictures Inserted in Excel Using VBA or Other Tools
Replies
1
Views
156
jolivanes
jolivanes
O
  • Solved
VBA - floating photo
Replies
3
Views
527
RoryA
RoryA
M
  • Question Question
Please help me to correct Excel VBA code!
Replies
1
Views
368
Minh Tuan VN
M
M
  • Solved
Word Header Text
Replies
1
Views
148
RoryA
RoryA

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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