Get Cell ID (eg. H40) at the top-left of the worksheet

[LamNgo]

Hi group,

Is there any way to identify which cell is now at the top-left
position of the worksheet area. At the first time, it's always the A1
cell but atfer user scroll, how can we now what is the first visible
cell on the left-top corner?

Thanks,
LamNgo

 

[jeff]

Hi,

I don't think so. I tried to do this
and there are a few objects, like charts and shapes,
that have the visible property, but not individual
cells.

jeff

 

[Dave Peterson]

How about:

Option Explicit

Sub testme01()

With ActiveWindow
MsgBox .VisibleRange.Cells(1, 1).Address
MsgBox .ScrollColumn & vbLf & .ScrollRow
End With

End Sub

But watchout for windows|freeze panes applied.

 

[BrianB]

'-------------------------------------------------------------------------
MsgBox (ActiveWindow.VisibleRange.Range("A1").Address)
'------------------------------------------------------------------------