Biff wrote...
Do you really need to reference the entire column?

Array entered:** (can't use entire columns)

=MAX((A1:F65535<"")*(ROW(1:65535)))
....

That's not an exact replacement for the OP's original formula. The OP's
formula would treat "" as a possible valid text string. The formula
above wouldn't. Exact replacement requires

=MAX((1-ISBLANK(A1:F65535))*ROW(A1:F65535))