Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell that is below given coordinates
Hi There,
Is there a simple way to determine the cell that is below a given set of (X,Y) coordinates? I need to know the cell that is below the upper left corner of a shape. I would to avoid doing of loop with conditions if there is a method to do that. I checked in the help without success - However I saw that the COM component has a procedure getCellAt for that. Thanks, MrT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell that is below given coordinates
Something like :
MsgBox Shapes("ShapeTest").TopLeftCell.Address NickHK "MrT" ... Hi There, Is there a simple way to determine the cell that is below a given set of (X,Y) coordinates? I need to know the cell that is below the upper left corner of a shape. I would to avoid doing of loop with conditions if there is a method to do that. I checked in the help without success - However I saw that the COM component has a procedure getCellAt for that. Thanks, MrT |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell that is below given coordinates
Thanks, great ! I justed need to add ActiveSheet. before shapes.
MrT "NickHK" wrote: Something like : MsgBox Shapes("ShapeTest").TopLeftCell.Address NickHK "MrT" ... Hi There, Is there a simple way to determine the cell that is below a given set of (X,Y) coordinates? I need to know the cell that is below the upper left corner of a shape. I would to avoid doing of loop with conditions if there is a method to do that. I checked in the help without success - However I saw that the COM component has a procedure getCellAt for that. Thanks, MrT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert point coordinates - pixel coordinates | Excel Programming | |||
Simple way to convert UTM ED50 coordinates to decimal coordinates? | Excel Programming | |||
Cell identification in x,y coordinates | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming | |||
Screen Coordinates of a given cell in XL | Excel Programming |