For just the one sheet? What is in column A, numbers or text?

You can create a dynamic named range. The range name may already exist called Print_Area.

If column A house numbers then change the name to refer to:
=!$A$1:INDEX(!$J:$J,MATCH(9.99999999999999E+307,!$A:$A))

If column A house text then change the name to refer to:
=!$A$1:INDEX(!$J:$J,MATCH(REPT("Z",255),!$A:$A))