Macro to Auto-adjust print area in a multiple sheets (excel 2010)

I have a multiple sheets (tabs) where each sheet have variable print range. 1 sheet may need to print 1000 rows, others may need 10 rows only to print. The good thing is that, my column range is fixed at B:G. My criteria of including a row will be the last cell under column G with actual value. It's because all of these columns are populated with vlookup formulas. It should not inculde a row with a value of "" under column G.

Hi there,

Try inserting the following code into the "ThisWorkbook" VBA CodeModule:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi,

I pasted the above code to "This Workbook" but if I print preview, I'm still seeing hundreds of pages instead of only 1 as per the criteria. It means that nothing happens. I'm still hopeful that someone can help me. thanks.

hi, can anyone help me?