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

Absolute position in Layout 2
Screen position of commandbar button in Excel 2007 ? 11
Place Text box at Mouse Pointer Position on a page 0
How to save a PDF with header that extends to edge of page? 3
Position of MsgBox on screen 3
Save Form Position on Close 4
How to get position of mouse via VB in a worksheet 3
Command button position and screen resolution 2

Top