Finding last row excluding formatting

[maym]

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:

Please Login or Register  to view this content.

How can I go to A10 instead of A1520?

[PCI]

Try

Please Login or Register  to view this content.

[Fluff13]

Another option

Please Login or Register  to view this content.

[Joske920]

Try what fits best is your opinion

Please Login or Register  to view this content.

mind that columns needs to be synced too

Grtz

[maym]

thank you! These options work great