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

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

Try using:

ActiveWindow.VisibleRange(1).Address

--
Regards

Juan Pablo González

"LamNgo" wrote in message
m...
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

Hi,
Thanks for your responses. But I'm finding for a correspondent C++
code segment using MFC 4.0 wrapper classes? I'm using VS 6.0.

LamNgo

"Juan Pablo González" wrote in message ...
Try using:

ActiveWindow.VisibleRange(1).Address

--
Regards

Juan Pablo González

"LamNgo" wrote in message
m...
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