I have a set of spreadsheets and each one has a blank line somewhere in the middle area. I need a formula that I can place at the bottom of each spreadsheet that returns the row number of the blank row. Alternatively, finding one blank cell and returning its row number would work as well if there is a way to do that. All help is very appreciated!

Control+shift+enter, not just enter:

=MATCH(TRUE,ISBLANK(A2:A100),0)+ROW(A2)-1

=MATCH(TRUE,A2:A100="",0)

Native row numbers:

Control+shift+enter, not just enter...

=MATCH(TRUE,ISBLANK(A2:A100),0)+ROW(A2)-1

=MATCH(TRUE,A2:A100="",0)+ROW(A2)-1