Recover last entered value in a specific column of Excel VBA

Question

I need to retrieve the last entered value in a specific cell of the worksheet, for example:

---

coluna ID
1
2
3
4
...
2550

---

I need to get the value of ID (2550) to be able to increase and execute other actions.

I tried using Range("A1").End(xlDown).Row, but it returns me the line number of the spreadsheet, but what I need is the field value.

Someone can help me with this problem?