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