Position of CellCursor on Screen (absolute position)

N

newsgroups

Hi NG,
I try to get the left upper corner of the current cell, which is
visible. The y-Value I get with:
ActiveCell.Top + Application.Top + (ActiveWindow.UsableHeight -
ActiveWindow.Height)
But there seems to be a unknown part. If I extend the commandBars so
that a new CommandBar-Line appears, the the top-position changes. Is
there a better way to get the top-position of a cell?

tx Joerg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Screen position of commandbar button in Excel 2007 ? 11
Position of MsgBox on screen 3
Capture Screen Position 6
How to got the position of a cell/range in pixels (from the left-top corner) ? 1
Get position of control 9
Adjust position of a commandbar 1
Position screen at end of macro 3
Positioning a Text Box 1

Top