Set Offset Function Range into print Area

[ibuhary]

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

Please Login or Register  to view this content.

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

Highlighted "ROW" function.

[ibuhary]

Macro code goes like this:

Please Login or Register  to view this content.