0

How do I find the last line/Row of an edited document meaning new information will be added to the document without my knowledge and I still need to be able to identify its address. VBA

TheCoder
  • 1
  • 1

1 Answers1

0
With ActiveSheet
    LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With

If you don't need VBA, then press Ctrl + Down Arrow in a column with continuous rows to bring you to the last row

Sean Kelly
  • 183
  • 3
  • 14