Use VBA to define print area?

[mailrush]

Hi, i've been trying to set a dynamic print area as a formula in the name manager to print only non-blank cells.

Attached is an example of the spreadsheet, using the following formula: =OFFSET(Cash Flow Sheet!$A$1,,,COUNTA(Cash Flow Sheet!$A$1:$A$45),COUNTA(Cash Flow Sheet!$A$1:$AZ$1))

Unfortunately I can't get this working.

Instead, is it possible to do this in VBA as a 'before print' command?

Cheers in advance

[mailrush]

can anyone help?

[mailrush]

or autohide columns that have blank results ("")?