Give this a go...


LastRow = ActiveCell.End(xlDown).Row



Mark

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