Thread: RangeFromPoint Only Finds ShapesAt 0, 0 coordinates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gfhunt gfhunt is offline
external usenet poster
  
Posts: 7
Default 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?
Reply With QuoteReply With Quote