Macro to Adjust Print Area

Hi, can someone please help me create a macro that automatically adjusts the print area of a worksheet based on a formula-driven cell value?

For example, say cells B2:K5 are full of vlookups that return percentage values while column A calculates the sum of the percentages (A2=sum(B2:K2). A1:K1 have column headers.

If I sort the worksheet by column A in decending order, I want the print area to only cover those rows where the value in column A is greater than 5%.

If for example, rows A2 and A3 are greater than 5%, I want the print area to include A1 to K3. I hope this makes sense. Thank you in advance for any help!

Please Login or Register  to view this content.

sorry

Please Login or Register  to view this content.

thanks for the help, but it doesn't seem to work. Here's the macro and I've attached a sample workbook (without the vlookups).

Please Login or Register  to view this content.

yea sorry. i had it working before i posted but then shut my book before saving. Its not working for me either.

no worries, thanks for trying. Does anyone else have a suggestion?

I probably did something wrong...but running that macro didn't do anything. I think I have an idea why though, and I'll try to get it to work tomorrow. Thanks for the help and I'll provide an update soon.

Assuming this doesn't work, are there any PrintArea macros that don't rely on Auto-filters? Perhaps another route would be to create a macro that:

1. Selects the rows where the value in column b is greater than 5%
2. Automatically adjusts the print area to include those rows
3. and then prints the file

Thoughts?