Excel an coordinates

[Marc Vanzegbroeck]

Hi,

Is there a way to find out the position of ex. the 3the row, and the 5th column in an excel-sheet?
I fill a sheet with data and at the end I do a autofit().
Then I want to add some bmp-files to the document, but I need to know the coordinates if the cell's.

Thanks,
Marc

[anserkk]

Code: Select all  Expand view

nRow:=oExcel:ActiveCell:Row
nColumn:=oExcel:ActiveCell:Column

Regards
Anser

[Marc Vanzegbroeck]

Anser,

Thanks for your reply, but this is not what I want.
This is returning the Columnnumber and Rownumber.
I want the Coordinates in pixels to add a BMP with

Code: Select all  Expand view

oExcel:ActiveSheet:Shapes:AddPicture( "TEST.BMP", .F., .T., 10, 10, 640, 400 )

Or is it possible to put it in an excel using the Columnnumber and Rownumber?
Regards,
Marc

[anserkk]

Or is it possible to put it in an excel using the Columnnumber and Rownumber?
Regards,
Marc

Try this. I have not tested

Code: Select all  Expand view

oRange:=oSheet:Range("J8")
oExcel:ActiveSheet:Shapes:AddPicture("TEST.BMP",.F., .T., oRange:Left, oRange:Top, 640, 400)
 

Regards
Anser

[Marc Vanzegbroeck]

Thanks Anser,

This is just what I wanted!!

Regards,
Marc