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
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