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