View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dianne Butterworth Dianne Butterworth is offline
external usenet poster
 
Posts: 7
Default How to get ID of the Cell on the Left-Top corner of a worksheet

How about:

ActiveWindow.VisibleRange.Cells(1, 1).Address

--
HTH,
Dianne Butterworth

In m,
LamNgo typed:
Hi group,

I there any way to find out the cell ID (eg. K36) of the cell on the
left-top corner of a worksheet. At the first time, it's always A1 cell
but after user scroll, how can we identify it?

Thanks,
LamNgo