| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RangeFromPoint Only Finds ShapesAt 0, 0 coordinates
I am trying to use the RangeFromPoint(.PointsToScreenPixelsX(ActiveCell.L eft), PointstoScreenPixelsY(ActiveCell.Top) to see if a Shape is already positioned over a cell so that if a shape is there I can delete it before pasting a new shape in its place. The RangeFromPoint command only returns the correct result if the shape is positioned at cell A1, otherwise it does not work. Any ideas?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup only finds #n/a's | Excel Discussion (Misc queries) | |||
| vlookup finds first match | Excel Discussion (Misc queries) | |||
| finds and concatenate | Excel Programming | |||
| Does RangeFromPoint Method return ranges? | Excel Programming | |||
| Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming | |||
Threaded Mode
