The standard way to find the last used row: start at the bottom of the sheet and press Ctrl + Up in code with End(xlUp). Works even with blanks in the middle of the data.

Code

lastRow = Cells(Rows.Count, 1).End(xlUp).Row

• Last row

  lastRow = Cells(Rows.Count, 1).End(xlUp).Row → The last used row in column A

  The pattern to memorize.

• Last column

  lastCol = Cells(1, Columns.Count).End(xlToLeft).Column → The last used column in row 1

  Same idea sideways.

• Build the data range

  Set rng = Range("A2:C" & lastRow) → The data block built from lastRow

  Then loop or read it.

• Pick a column that is always filled, like an ID column.
• Qualify with a sheet: ws.Cells(ws.Rows.Count, 1).
• UsedRange is unreliable for this; End(xlUp) is not.

• Returns 1 on an empty column, so a loop from 2 To lastRow runs zero times, which is usually fine.
• Filtered or hidden rows are still counted.