Macro to set variable print area

[hcdemo]

I am new to creating macros so I would like some help to create a macro to
set the print area on my worksheet. I want to set the width to a constant and
basically need to set the length or number of sheets that print so I do not
have many blank pages and so I do not cut of wording.

I have cells with formulas in that sometimes fill in if certain criteria are
met and when the criteria is NOT met the formulas go to "" or blank. I only
want it to print if criteria is met.

Any suggestions?

Thanks