Setting Print range based on cell data

lucky12341

Board Regular
Joined
Nov 4, 2005
Messages
121
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,660
Members
412,481
Latest member
nhantam
Top