Set Offset Function Range into print Area

I want to fix the following range derived by the offset function into the print area:

Formula:

Offset(R1C1, SumProduct(Large(Row(C1) * (C1 <> """"), 1)) - 12, 0, 12, 8)

The Problem is when I use it inside a Macro there is an error:
"Sub or Function Not Defined"

Highlighted "ROW" function.