Hi,

I'm trying to get the screen location of a Range object. Currently
I'm doing (C++):

CRange range = application.get_ActiveCell();
int rangeLeft = int(range.get_Left().dblVal / 0.75 ) + 25;
int rangeTop = int(range.get_Top().dblVal / 0.75) + 16;
pWnd-ClientToScreen(&ptForBalloon);

But this obviously has some problems (doesn't handle zooming,
multiple panes, etc).

I found some nice code by keepITcool that handles most of this:
http://groups.google.com.au/group/mi...9aac2dde2e778/

But it still doesn't handle Panes.

Anyone know a full solution?

Some other questions:
1) PointsToScreenPixelsX doesn't show up in my VS generated C++
wrappers. Any idea how to deal with this?
2) What I *really* want is to be able to select/get the location of
some text within a cell, not the cell itself. Is this possible?

[The reason I want to do this is to support Excel in my HandyFind
freeware that lets you Find as You Type and displays a balloon to guide
your eye to the found text. I put a preview including Excel support at
http://www.handykeys.com/preview in case you are interested. Any
feedback is much appreciated. Please send it to the email address on
that page.]

Thanks!
-Edwin Evans