Setting Print Area based on Columns

Hi Everyone,

I need help with creating a macro to set the print area on a spreadsheet with variable number of rows and columns (The number of rows and columns will be different every time the report is generated), any suggestions?

Thanks,

Dennis