Thread: HOW TO FIND last cell from activecell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default HOW TO FIND last cell from activecell?
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




Reply With QuoteReply With Quote