Dear MARK IVEY, GARY"S STUDENT AND PER JESSEN,
I DONT KNOW WHY MY RESPONSE TO MR. MARK SAYING THAT VB line worked did not
get posted. However pls accept my thanks for helping me out. How i wish if
you all could also help me for my previous thread why in one particular sheet
I dont get to see the edit-fill"series" option highlighted in excel 97.
Whereas in any other worksheet this option for "series" is highlighted and
available. Pls dont say i shud not mix two threads but somehow this nagging
one going on for last one year and no one is answering including todays
posting.

"Per Jessen" wrote:

Hi

Using xlDown will move to the last downmost cell in the serie.

LastCell = ActiveCell.End(xlDown).Address

Regards,

Per

"CAPTGNVR" skrev i meddelelsen
...
DEAR ALL

Excel97: in COL A, have say 50 rows 1 to 50. Again have row 70 to 150
another seiral numbers 1 to 80.

Suppose if cell A25 is clicked, how to use countA to find the last cell in
row 1 to 50.

Pls bear in mind that xlup etc cant be used bcos from row 70, i have
another
serial numbers.

Pls sugest what VB. Thnks