Hello Excel Experts,

I have 2 formulas here that find the last row and last column without VBA.

I tried to put them together, so that I'm able to have the last row and column on a named range. Would experts please assist me.

Thank you!

Last Row without VBA
=A3:INDEX(3:3,COUNTA(3:3))
Last Column without VBA
=A3:INDEX(Sheet1!A:A,COUNTIF(Sheet1!A:A,"<>"))