ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RangeFromPoint Undocumented Returned Object (https://www.excelbanter.com/excel-programming/306520-re-rangefrompoint-undocumented-returned-object.html)

Tushar Mehta

RangeFromPoint Undocumented Returned Object
 
What does the Typename() function return? I find it to be a very
powerful tool in understanding what kind of object various entities
return and use it heavily when dealing with embedded OLE objects.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Does anyone know what type of object RangeFromPoint() will return when you
pass in the screen coordinates above a cell with an In-Cell dropdown?

A COM object is being returned that is neither a Range object nor a Shape
Object. The Excel reference says that RangeFromPoint() returns a Range
Object, a shape object, or Null. It doesn¤=3Ft mention any other object types.
I need to know what type of Excel object to cast this object to.

Thanks



All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com