Setting Print range based on cell data

[lucky12341]

Is it possible to make excel define its print range based on cell data? Basically I have a document and I want it to print a row from column A to I if column B has information. I need it turn run through about 15,000 rows and print those selected rows. I looked through the message board for about an hour and found similar things but I wasnt able to get them to run.

lucky

 

[Andrew Poulsom]

You could try an AutoFilter for NonBlanks in column B to hide the rows you don't want printed. Then you wouldn't have to change the Print_Area.