Finding last row excluding formatting

Hi,

I have a spreadsheet with formatting (sample attached).

I am trying to locate the first empty row (in this case it is cell A10) but because the sheet is formatted, it goes straight to the last row with formatting (A1520).

I am using the below:

last_row = Sheets("ORDERS").Range("A65536").End(xlUp).Row

How can I go to A10 instead of A1520?