View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] newsgroups@joerg-lensing.de is offline
external usenet poster
 
Posts: 1
Default Position of CellCursor on Screen (absolute position)

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